Form not sending data to table

B

Becky

I am using Access 97 and I have a form set up that does
several calculations for a percentage score, but the data
calculated on the form is not going to the table. There is
no data there for those fields so when I run a query no
score is showing on the query?
 
T

test

In general you should not store caklculated data in a table. You should
repeat the calculation whenever the value is required. So, you might have
the same forumla in the form (to display the calculated value), and again in
the query (for the same purpose). Or, you could define the calculaytion as a
Public Function in a standard module, & use the function from the form & the
query, so you only have to write the code once.

HTH,
TC
 
Top