G Guest Mar 1, 2004 #1 I have a table that I want to run simple subtraction and/or addition on the data. Suggestions?
F fredg Mar 1, 2004 #2 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.
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.
G Guest Mar 2, 2004 #3 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!!!
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!!!
