CALCULATIONS DO NOT COME UP IN TABLE

F

FC

I HAVE A TABLE FROM WHICH I DESIGNED A FORM AND IN THE FORM DO SOME %
CALCULATIONS, THE FORMULA IS WRITTEN IN THE PROPERTIES BOX FOR THAT FIELD IN
FORM, BUT I AN NOT SURE WHERE TO WRITE THE FORMULA IN THE DESIGN OF THE
TABLE, AND SO THE VALUES DO NOT COME UP IN THE TABLE IT JUST STAYS BLANK IN
THAT COLUMN.
PLS HELP!!!!!
THANKS
FC
 
R

Rick Brandt

FC said:
I HAVE A TABLE FROM WHICH I DESIGNED A FORM AND IN THE FORM DO SOME %
CALCULATIONS, THE FORMULA IS WRITTEN IN THE PROPERTIES BOX FOR THAT
FIELD IN FORM, BUT I AN NOT SURE WHERE TO WRITE THE FORMULA IN THE
DESIGN OF THE TABLE, AND SO THE VALUES DO NOT COME UP IN THE TABLE IT
JUST STAYS BLANK IN THAT COLUMN.
PLS HELP!!!!!
THANKS
FC
Click to expand...

It is a violation of proper database principles to store values that are the
result of calculations. Put your calculation into a query and use the query
instead of the table.
 
A

Allen Browne

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains why you do not want to store calculated results, and
explains how to if you want to proceed anyway.

You might also have a look to see if your keyboard has a CapsLock key so
people here don't think you are shouting at them.
 
J

John Vinson

I HAVE A TABLE FROM WHICH I DESIGNED A FORM AND IN THE FORM DO SOME %
CALCULATIONS, THE FORMULA IS WRITTEN IN THE PROPERTIES BOX FOR THAT FIELD IN
FORM, BUT I AN NOT SURE WHERE TO WRITE THE FORMULA IN THE DESIGN OF THE
TABLE, AND SO THE VALUES DO NOT COME UP IN THE TABLE IT JUST STAYS BLANK IN
THAT COLUMN.
PLS HELP!!!!!
THANKS
FC
Click to expand...

Please DON'T SHOUT. It's hard to read and it's considered impolite.
Type in all lower case if you have trouble using the shift key.

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]
 
Top