Refer to previous records results

[AccessVB]

Cannot figure this out..

Have the following query results:

Date Balance Due Due Recd Outstanding

3/31/04 100.00 10.00 90.00
4/30/04 xx

xx should be 90.00 from the previous records calculations. So like we can refer to previous row's cells in excel, can we do the same in Access queries?

Help much appreciated...Thanks.

 

[mhcruella]

There's not a way I know of that will work using a query. I would suggest doing this with recordsets. There is a way with the UNION operator to dispay summary information in your datasheet, but I don't think this is what you want. If you need help with the recordsets let me know.

 

[AccessVB]

Ok. thanks. Seems strange though for access not to have this simple functionality. I have worked a little bit with recordsets in the past. If I get stuck I will shout out again...

Many Thanks.

 

[Crowley16]

it's not access that doesn't have this function...

it's that SQL doesn't work that way...