-
What is the proper SQL statement to make Access automatically add or subtract currency entries in a table? I am trying to make a virtual checkbook app that will add or subtract from the balance according to whether the entry is a deposit or deduction.
I don't wan't the user to have to do the math :)
Any help is greatly appreciated.
Daniel Christie
-
You could either use the UPDATE sql statement or a calculated field on a form.
As you asked for SQL something along these lines;
UPDATE TableWithCurrencyData
SET CurrencyField = CurrencyField + AmountToAddOrSubtract
WHERE IdOfRec = ReqID;
Obviously the variable we are adding could be +ve or -ve.
Hope this helps.
Regards,
John.
