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?

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.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"leerinder" <(E-Mail Removed)> wrote in message
news:FC21EA27-6E92-4C07-81B8-(E-Mail Removed)...
> 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?