Microsoft access Problem Please help

[Nick Lewis]

Hi i was wondering if anyone could help me with a access problem I'm having

Firstly some details. I have a table in which performs various calculations
which all work fine no problems at all. from this set of calculations i would
like a total using the control source =sum([ProductionPacks]) this also works
fine and brings up a total. How can i then get this total to save in the
table as it does not currently the tables name is Product?

Any help would be gladly received

(e-mail address removed)

 

[Douglas J. Steele]

You shouldn't store it.

You run the risk of your stored value getting out of sync with reality, so
you're better off recalculating it each time.

 

[John Vinson]

On Fri, 14 Jan 2005 07:09:01 -0800, "Nick Lewis" <Nick

Hi i was wondering if anyone could help me with a access problem I'm having

Firstly some details. I have a table in which performs various calculations
which all work fine no problems at all.

Ummm... No. You don't. Tables DO NOT perform calculations; queries do.

from this set of calculations i would
like a total using the control source =sum([ProductionPacks]) this also works
fine and brings up a total. How can i then get this total to save in the
table as it does not currently the tables name is Product?

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]