DateAdd for expiry and reminder dates

[Guest]

Rephrazing a previous question. Preabmle: understand that a table filed
should not contain a calcualted value, how do I work around that to achieve
the following:

Items being received on any given date will have a default expiry date of 3
months, however users may overide that to any expiry date they wish. also
want to set a reminder date for 7 days prior to expiry date. Need to be able
to store data as report on reminders due to be sent and expiring items on any
given day. \

Seems I can use DateAdd("m",3,Date()) as the default value for the expiry
date, but not DateAdd("m",3,[ReceivedDate]) - is it not possible to do that ?

 

[Douglas J Steele]

It's not possible in a table, but then you shouldn't be using a table to do
your updates.

In a form, you can easily set the value of any field in the Current event of
the form and/or the AfterUpdate event of whatever control(s) impact the
value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Rephrazing a previous question. Preabmle: understand that a table filed
should not contain a calcualted value, how do I work around that to achieve
the following:

Items being received on any given date will have a default expiry date of 3
months, however users may overide that to any expiry date they wish. also
want to set a reminder date for 7 days prior to expiry date. Need to be able
to store data as report on reminders due to be sent and expiring items on any
given day. \

Seems I can use DateAdd("m",3,Date()) as the default value for the expiry
date, but not DateAdd("m",3,[ReceivedDate]) - is it not possible to do

that ?