calculations in a querie

[Guest]

I am trying to calculate the value between 2 numbers in my querie.

Value one is supposed to be subtracted from value 2 and then displayed in another cell, when I try to do this it gives an error message of something about an IF something something... I cannot subtract the cell from the other cell, HELP!! )

 

[Rick B]

Telling exactly what the error message says would probably give us a lot
more to go on. Someone at Microsoft went to a lot of trouble to program
them.

To create a calculated field, you need to go to a new blank column and enter
something like...


Difference: [Value1] - [Value2]


Rick B


I am trying to calculate the value between 2 numbers in my querie.

Value one is supposed to be subtracted from value 2 and then displayed in
another cell, when I try to do this it gives an error message of something
about an IF something something... I cannot subtract the cell from the other
cell, HELP!! )