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!! )
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!! )
)