Access is a database, not just a giant spreadsheet.
There is no provision for specifying calculations in a table. If
calculations can be done with data that is available at the time of their
use, they should be done in a query, form, or report.
If the data used in the calculation may change, but the calculated value
should still be retained, the value may be copied from the calculated
Control into a bound Control to be saved in the Table, or the calculation
done in VBA code and saved into a bound Control.
Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.
Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
