Calculations in my Form are not written back to the original table

J

Jay

Hi

I have a table which contains all the fileds in the database.

I have a form which is used for data entry.

On this form I have fields (which exist in the original Table) where
calculations and their results are correctly displayed.

Unfortunately the calculated fields do not populate their corresponding
fields in the original table.
This makes queries and reports run against the table meaningless.

How can I resolve this ?

Thanks

Jay
 
D

Douglas J. Steele

As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the total may be changed, making
the value WRONG."

Put the calculations in a query, and use the query wherever you would
otherwise have used the table.
 
G

gls858

Jay said:
Hi

I have a table which contains all the fileds in the database.

I have a form which is used for data entry.

On this form I have fields (which exist in the original Table) where
calculations and their results are correctly displayed.

Unfortunately the calculated fields do not populate their corresponding
fields in the original table.
This makes queries and reports run against the table meaningless.

How can I resolve this ?

Thanks

Jay
Click to expand...

Calculated values should never be stored in a table. Add the calculation
to the query or the report using an expression. Check the link below for
some examples.
http://office.microsoft.com/en-us/assistance/HA011814491033.aspx

gls858
 
Top