add 3 weeks to an date column in access table

[Guest]

Hi
I have an access table with a date column and I want to add another column
that adds 3 weeks automatically when I enter a date in the first column
Please help

 

[Guest]

Use the DateAdd function, check help on the subject, you'll have example

' To add three weeks to a field
Select MyDateField, dateadd("ww",3,MyDateField) as NextDate From MyTable

 

[Joseph Meehan]

You don't. You just use a calculation to make up that date anytime you
want to use it, not store it in a table.

Access works better re-computing the new date than looking it up.;

Doing it right also eliminates the problem if someone would need to
change the original date and then forget to change the second date.