What is the proper SQL statement to make Access...

[Daniel_Christie]

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

[J Staniforth]

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.