How Is DateAdd Used As A Before Update Event

[Guest]

I'm using a form to input data into a several tables & in one of my tables
[Maint] I'm trying to automatically add three (3) years to the field
[Acquired] & have this new value input into a different field [Initial
Warranty Expiriation].
Yes, I need this value in the table because it will be used in several
computations & queries later on.
I've tried using Expresssion Builder to create
=DateAdd('yyyy',3,Maint!Acquired) with no result. I've even modified it to
DateAdd('yyyy',3,[Maint]![Acquired]) again with no result.
Can some please show me the errors of my way !?!?!
Thanx in advance.
John

 

[Graham R Seach]

John,

<<Yes, I need this value in the table because...>>
No, you don't need to store it. In order to use it, you'd need to acces the
table, in which case, you may as well access [Acquired], and perform the
calculation on it as needed.

So that you can see it on the form, you can use the following:
=DateAdd("yyyy", 3, [Acquired])

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia