Query Calculation

  • Thread starter Thread starter RobinF
  • Start date Start date
R

RobinF

How would I write a Query that takes a figure from a
field then adds or subtracts from another field to put
the balance in another seperate field.
Thank you
 
In a new column of the query type something like this:

Total: [number1]+[number2]
(don't forget the colon) This give a new field in the query with the name
"Total"

You can use *,/,-,+

This will do the calculation for you.

HTH

Tony
 
Back
Top