Running Sum Problem

[zashmore]

Hi All,

I have searched and searched, and searched some more.
I still cannot get this to work.

I have a simple Table of -

[IDNo]
[PaymentNo]
[PaymentDate]
[PaymentAmount]

I want to create a running total in a query for each IDNo.

What's the best way of doing this?
DSum?
Crosstab?

Please help.

 

[Guus2005]

Its GROUP BY you are searching for and if IDNo is unique, leave it out of the query.
I believe you need PaymentNo and PaymentAmount in your query:

select PaymentNo, Sum(PaymentAmount) from SimpleTable Group By PaymentNo

Share & Enjoy!