I am relatively new at Access and need to find a way that when one date is selected, the other 3 date fields are updated. I am guessing a query would be best. My fields are:

Week Start Date This date will be selected from a combo box so that a wrong date is not entered.
Week Finish Date (6 days after the start date)
Invoice Date (9 days after the start date)
Check Date (13 days after the start date)

Your assistance is appreciated.

I tried doing a query, however, the syntax I used is apparently incorrect:

SELECT DateAdd(“d”,6,[WeekStartDate]) AS NewDate FROM [tblStartDates]