Update underlying table

[TeeSee]

Have a simple table, query on the table and a form based on the query.
In the query I have a calculated field using the DateAdd function. How
do I update a field in the table with the calculated answer?

Thanks in advance

 

[Jeff Boyce]

Don't! If you can calculate the value, why store it? Use a query (or your
form) to calculate it on the fly.

If you store a calculated value, you'll have to add the code needed to
ensure that the calculated (stored) value stays synchronized with the other
fields used to calculate it. For example, what happens in your
database/table if someone slips into the table and corrects a mistake on a
record, changing the original date?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[TeeSee]

Thanks Jeff ... That makes sense to me. Regards

Don't! If you can calculate the value, why store it? Use a query (or your
form) to calculate it on the fly.

If you store a calculated value, you'll have to add the code needed to
ensure that the calculated (stored) value stays synchronized with the other
fields used to calculate it. For example, what happens in your
database/table if someone slips into the table and corrects a mistake on a
record, changing the original date?

Regards

Jeff Boyce
Microsoft Office/Access MVP