Calculations

Jennifer · Apr 18, 2005

I created a form in access and when the info moves over to its table, I lose
the calculated cells, in other words those cells become blank. What can I do
to keep these calculations in the Table also. I would really appreciate any
help I can get on this.

Rick B · Apr 18, 2005

PLEASE SEARCH BEFORE POSTING. This is asked ALLLLL the time. It was
answerred at least once TODAY.

The answer is.....

You DON'T store calculations in a table. Read the previous posts for more
details. That is why they stay out there.

http://groups-beta.google.com/groups?q=microsoft.public.access+"store+calculated+fields"&qt_s=Search

Rick B

Lynn Trapp · Apr 18, 2005

Jennifer,
In about 99.9999% of the cases, you don't need to store the results of a
calculation in your tables, because you can always recalculate it when you
need it.

Lynn Trapp
MS Access MVP