why a caulculated field in form does not show up in the table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a database, and i also created a form that i use cauculated
fields inside the form. I have serveral cauculated fields but only some are
showing up in the table while others do not show anything but a 0.00 in the
table. when i query the information its not correct becasue the cauculated
fields do not show information.
 
Typically, you don't store calculated values in a table. If you will
search, you'll find hundreds of previous posts on the topic. To quote just
one of them from an MVP...
Why not to store a calculated value
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.



John W. Vinson [MVP]



Hope that helps,
 
Back
Top