I am writing a program for handling bank deposits, check writing, check register, and general ledger.
I need to make the check amount a negative number, which I can but it won't render correctly as text for the written line of check. I have Bank Balance as a Running Total for deposits. I should be able to continue beyond that function to have the amount of a check deducted from Bank Balance. Seems the easiest way but haven't done something correctly since it doesn't work.
Any suggestions appreciated.
ferg
Am I correct that you need to write a check for say $500.00 but need the amount to be negative in your table so that the correct balance is calculated?
There are two ways to do that. The simplest given your current design would be to add a calculation field that uses the abs function to render the negative as a positive. You could then use abs ( -500 ) to get 500 to use for printing the check.
An "old school" approach is to use one field for withdrawals and one for deposits typical of a bookkepping ledger or check register. Then the value is stored as a positive value in the first place and you sum a calculation field: Deposits - Withdrawals in order to calculate the account balance.