calculated columns in a datasheet

[Guest]

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

 

[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.

 

[Joseph Meehan]

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

For computed values, you don't store them in fields of a table, you
compute them as needed.

They can be computed In a query, a form or a report.