Copy form data into table

A

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
 
R

Rick B

Do a search - Asked and answered all the time.

You don't store calculated values.
 
D

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