Copy form data into table

[Adam]

Hi All,

Forgive me if this is a stupid question.

I have a form which has some fields on it, and two calculated fields
from the four other fields.

Is it possible to have the data in the calculated fields to be input
into another table?

I want to only copy, Name, calculated field 1 and calculated field 2.

Is this possible?

Adam

 

[Rick B]

Do a search - Asked and answered all the time.

You don't store calculated values.

 

[Douglas J. Steele]

Calculated data shouldn't be stored, it should be recalculated. What happens
if you change a value in the first table, but forget to recalculate the
value for the other table? How will you know which value is correct?

If you're determined to do this, you can use an INSERT INTO or UPDATE query
in the form's AfterUpdate event to update the other table.

 

[Adam]

No, I can see your logic and will use it now.

Thank you

Adam