Form not sending data to table

  • Thread starter Thread starter Becky
  • Start date Start date
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?
 
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
 
Back
Top