Rolling Total in a QUERY!!

Chimp8471

Registered User.
Local time
Today, 16:58
Joined
Mar 18, 2003
Messages
353
is it possible to have a query carry out a running total, so that it counts the record above and the current entry.....

example

Record 1 Total 10 Running total 10
Record 2 Total 10 Running total 20
Record 3 Total 30 Running total 50
Record 4 Total 5 Running total 55

as i said i need this done in a query if Possible...

anyone help?
 

Users who are viewing this thread

Back
Top Bottom