Calculations

[Guest]

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]

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]

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

 

[Joseph Meehan]

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.

It's smarter than you are. Don't try to fix it. You don't want to
store results in Access (or other databases, you just re-compute them.
Works much better.