add 3 weeks to an date column in access table

C

Casper

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
 
O

Ofer

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
 
Top