How do I add or subtract

J

John

I have a table that I want to run simple subtraction and/or addition on the data. Suggestions?
 
F

fredg

I have a table that I want to run simple subtraction and/or addition
on the data. Suggestions?
Click to expand...

Well, you can't do addition and subtraction in the table.

Access has queries, forms, and reports which can do math calculations.

If you wish to add one field to another, for instance in a query, you
would write:
NewField:[Field1] + [Field2]

or ...
In a Form or Report's unbound control:
= [Field1] + [Field2]


The result would not be saved in any table, as any time you need the
calculation, simply repeat it.
 
J

John

Thank you....I feel like an idiot, I was putting the calculation in the criteria part of the query, then it hit me....enter it in the field and it works perfectly. Thanks for your help!!!
 
Top