Groundrush
Registered User.
- Local time
- Today, 11:57
- Joined
- Apr 14, 2002
- Messages
- 1,376
I am trying to keep a running total of money left over after paying money out.
What is the best way to carry the balance over ?
I have a Debit and Credit field and in my query I have typed in Balance:[Credit]-[Debit], which works for the first record
but give a negative value for the rest.
any ideas?
Thanks
What is the best way to carry the balance over ?
I have a Debit and Credit field and in my query I have typed in Balance:[Credit]-[Debit], which works for the first record
but give a negative value for the rest.
any ideas?
Thanks