use datasheet view of a form as table

D

David S.

In form view I've made several calculations that work on the form but doesn't
get to the table. When I view the datasheet view of the form it has all the
calculated fields in it. Can I somehow us this information as a regular
table? Or failing that somehow get the calculated fields of the form into my
database table?
 
D

Douglas J Steele

Why do you want the calculated values in the table?

As fellow MVP John Vinson likes to say

"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"
 
F

fredg

In form view I've made several calculations that work on the form but doesn't
get to the table. When I view the datasheet view of the form it has all the
calculated fields in it. Can I somehow us this information as a regular
table? Or failing that somehow get the calculated fields of the form into my
database table?
Click to expand...

Calculated data, as a rule, should not be stored in your table. Store
only the data that is used in the calculation. Then whenever you need
to result, re-calculate it, as you are doing now.
 
L

Larry Linson

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.
Click to expand...

I have an acquaintance who is a retired DBA (for server and mainframe
databases). He uses the general rule that: "If you have the same information
in two places in your database, they are BOTH wrong."

And, as far as the data being usable, that is correct -- if you don't know
which of the two is correct, then you can't rely on either of them being
right.

Larry Linson
Microsoft Access MVP
 
Top