PREVIOUS RECORD VALUE

[laveshhp via AccessMonster.com]

HELLO
PLEASE CAN SOMEBODY HELP ME OUT ON THIS PROBLEM
I AM WRITING AND ACOUNTING DATABASE AND I NEED TO GET THE PREVIOUS RECORD
FIELD (WHICH IS SUM( "A" FIELD + "B" FIELD)
E.G
DATE FIELD A FIELD B TOTAL (FIELD A + FIELD B)
9/1/2006 100.00 100.00 200.00

NOW I NEED IN QUERY LIKE THIS

DATE OPBALA NCE FIELDA FIELDB TOTAL
9/2/06 200.00 50.00 50.00 300.00
9/3/06 300.00 100.00 100.00 500.00
9/4/06 500.00

THANKS
LAVESH

 

[ManningFan]

This is why sites like www.rentacoder.com exist.

Since you won't have records for all 7 days/week, the only way you're
going to get that to work will be to use an array.

 

[pietlinden]

or he could go the easy way and automate Excel... or would that be too
easy?

 

[Guest]

The other link:
http://support.microsoft.com/defaul...port/kb/articles/q210/5/04.asp&NoWebContent=1