Populating field in table based on calculations from other fields

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I am wondering if it is possible to populate a defined
field in a table with the result of a calculation from two
or more existing fields.

Thanks.
 
I am wondering if it is possible to populate a defined
field in a table with the result of a calculation from two
or more existing fields.

Thanks.
Click to expand...

Yes, using an Update query - but!

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.
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Populate a new field in an existing table 2
Populating Fields Automatically 2
Auto Population of fields 1
Calculating Fields in a Table 6
validation for one field based on another 1
how to add a formula to a field to auto calculate 2
Auto Populated Field 2
Access Updating inventory levels 0

Back
Top