Ask Experts Questions for FREE Help !
Ask

Problem of running sum in query and report

Asked Jan 24, 2012, 03:43 AM — 1 Answer
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.

Search this Thread
Share |
1 Answer
ScottGem's Avatar
ScottGem Posts: 58,169, Reputation: 28165
Computer Expert and Renaissance Man
  
#2

Jan 24, 2012, 03:52 AM


Have you checked out these tutorials on running sums?

Running Sum Download Tutorial
ACC2000: How to Create a Grouped Running Sum in a Query

You should not have a balance field in your tables. To calculate a running sum, you need to add the incoming amounts and subtract the outgoing ones. So using a DSum is correct, but not the way you are using it.

Check out those articles and, if you have more specific questions, please ask.
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

Report Sum totals [ 7 Answers ]

Hi there, I have made a report from a query. I want to sum the totals from a totals column. I have had luck summing the totals from my other columnms by putting a text box control source to =sum(Name) of the appropriate textbox. However for this column I use the same expression =sum(Name)...

Creating a report/query in Access [ 16 Answers ]

I have an acess Database that my boss set up for me. I enter in employee names what time they sign in sign out for lunch sign back in and sign out for the day.... How do I make a report/or query that can give me a monthly average for each person?

Sum result stored in text box in vb data report [ 1 Answers ]

I have two text boxes to sum in detail section of vb data report and I want to sum in 3rd text box like this in detail section : rpttext1 = rpttext2 + rpttext3

Sum two fields in detail section of vb data report [ 1 Answers ]

Dear Sir, I am using VB Data report and I am getting problem in putting formula How can I get result of sum of two fields in detail section of data report like: Text1= Field1 + Field2 (Detail Section) Please give me an early reponse.

View more Access questions Search