calculated columns in a datasheet

B

bladelock

Good day all

I have a datasheet that I input records to. The fields (numeric) are
"removed" "return" "variance" I just want to be able to type into the
"removed" and "returns" and have the "variance" automatically give me the
difference. What do I have to do my datasheet (not a form).

Ex. 2 3 = 5
4 -1 = 3

thanks
 
N

Nick Coe \(UK\)

Access won't work like Excel. You are using Access aren't
you?

Access being a relational database you don't store the
results of calculations, you just recalc them each time you
need them.

To calculate the result you use a query.
 
Top