Calculation HELP

C

Chris

I need help do calculation.

I want to see the differences between two columns

I would like to insert a column that will give me the result if I table the
value in column one and subtract it from column two

CAN SOME ONE PLEASE HELP WITH THIS ASAP!!!!!!!!!!!!!!
 
D

Designing-Systems.com

hi,

If the two colums are "number" data types then you can simply use the
following query to perform the subtraction:

SELECT Table1.Field1, Table1.Field2, [Table1]![Field2]-[Table1]![Field1] AS
Subtracted
FROM Table1;

If the tables are not numeric, you can include the expression to convert the
string to a numeric value if IsNumeric returns true.

Regards,
 
Top