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

[Guest]

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

 

[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.

 

[gls858]

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

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

 

[Guest]

Hi Guys

Thanks.

Shall try the calcs in the query and will value the URL sent

Jay