Running Total

[Kjuib]

I made a query that pulls the list of Invoices for some
Customers. The Query tallies a Running Total for all the
Invoice Amounts. Now I need the Query to start the Running
Total over when it gets to a new Customer. So, the Query
should keep a running total of all Invoice Amounts for
each Customer.

 

[Dennis Schmidt]

Hi ,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

Sorry, that is not possible in a query. You would only get this
functionality in a report.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Alfred]

Use dsum in your query to get running totals
Alfred