Running Total in a Query

[mikejaytlabustro]

Anyone can help me please?

Sample Data in a Query:

MyDate Amount RunningTotal***
01/01/2014 100.00 100.00
01/02/2014 50.00 150.00
01/03/2014 -25.00 125.00

--------------------------------------------------
*** I don't know the code to write in RunningTotal

 

[namliam]

The later part of this 2 hour old post by me should help you:
http://www.access-programmers.co.uk/forums/showthread.php?p=1330349#post1330349