Subtracting from Previous Rec

[jkjmwilliams]

On a new record, I would like to show the amount from the previous record
(the remainder). The new record will have a new amount entered into Amount.
Another field will contain Remainder-Amount , which will then be passed to
the new record. Can you tell me how to achieve this?

 

[Tom van Stiphout]

On Thu, 2 Oct 2008 18:39:00 -0700, jkjmwilliams

That's a variant of ths issue discussed in this KB article:
http://support.microsoft.com/kb/210236

-Tom.
Microsoft Access MVP

 

[AccessVandal via AccessMonster.com]

Create a new control (text box) and in the control source, input

DSum(“NewAmountâ€, “TableNameâ€)

Or

[Control1] – [Control2]