Problem of running sum in query and report
With the help of Internet Search Engine I found your name as a tutor of ms access. Can you help me to solve my problem?
I just want Running Sum in a Query in my daily transactions of the customer FILTER BY ACCOUNT NUMBERS seprately. The fields of which we are calculating is:
CLOSING BALANCE = OPENING BALANCE BILL AMOUNT - PAYMENT RECEIVED
I am sending you my database structure for the ready reference. Through Dsum Command I am trying to display thr running some but not susscess. Let me see my formula of Dsum kindly correct them.
CLOSING BALANCE: DSum("[OPBAL] [BILL AMOUNT]-[PAYRCVD]","[LEDGER]","[ACCNO]=" & [ACCNO] & " AND [TID]<=" & [SLNO])
Kindly help me to sort out the problems
Thanking you,
Yours faithfuly,
Smaaq.