DateAdd Again

[mossie]

Hello

Right I think I know a little more now but still need some
clarification.

This is what I am trying to achieve. I have a start date field in my
core information table/form. When the user enters this date into the
field on the form I want it to use the dateadd function to add 6 months
to it and then write the result into the QC Review date.

I have worked out how to do this via a query but not via the on-update
option of the field. I do need this information saved to a field and
not calculated at the time of running the form.

Any help would be greatly apprecited.

Kind Regards
Hamish

 

[R. Hicks]

You can calculate the result when needed "on demand" dynamically.
The result should not be stored in your table as it violates the First
Normal Form (1NF).
There are only certain special occasions where it is considered
allowable to save a calculated result in a table .. and this is not one
of them.

RDH

 

[mossie]

Thanks for a such a helpful and informative response. Care to elaborate
on the how exactly I should do it then?

Regards
Hamish

 

[R. Hicks]

Basically .. if you can calculate the value now ... and the values the
calculation is based on are stored ... then you can calculate the
result again "on the fly" when the is need again ...

This is the only way you can be 100% sure the calculated result is
correct upon execution.
When storing the calculated result .. the result becomes a "static"
value.
If any value the result is based on should get changed for any reason
.... the stored "static" calculated result will be incorrect.

RDH