Calcutations in access

A

Amanda

I have two feilds in a table A & B, which I want to calulate (A * B = C) and
record the answer in feild C. In my form I have it calculating but it's not
recording the data in the table.
 
R

Rick Brandt

Amanda said:
I have two feilds in a table A & B, which I want to calulate (A * B = C) and
record the answer in feild C. In my form I have it calculating but it's not
recording the data in the table.
Click to expand...

And it doesn't need to be nor should it be. Easily derived calculation results
should never be stored (you don't store them in Excel, why store them in
Access?).

Create a query based on your table (from which you have removed field C) and add
the calculation for C to the query. Now simply use the query in all places
where you would otherwise have used the table.
 
Top