creating calculations

[leerinder]

I am setting up a home inventory database. I want to calculate a field for total value. This field will multiply the quantity by the value to create a total value. I have created the calculated field in the forms view, but it doesn't transfer when I look at the data base in the table view. How can I get this calculated field (column) to show in the table view?

 

[Allen Browne]

Use a query to display the calcuated field. Do not store the result back in
the table (unless you have a good reason in mind why the field should ever
be *different* than the calculation.)

For an quick explanation of when and how to store a calculated result, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am setting up a home inventory database. I want to calculate a field

for total value. This field will multiply the quantity by the value to
create a total value. I have created the calculated field in the forms
view, but it doesn't transfer when I look at the data base in the table
view. How can I get this calculated field (column) to show in the table
view?