Calculation HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!!!!!!!!!!!
 
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,
 
Back
Top