Rounding Dates Up To Monday?

Hi all,

I have a 'StartDate' field which must always fall on a Monday and is based on a previous date + interval.

If this StartDate falls on a day of the week other than Monday, I need to add the appropriate number of days to bring it to the following Monday.

This can be done using 6 Update queries (one for each day) such as below but is there a neater way of doing all 6 in one go?

Thanks in advance.


UPDATE JobCards
SET JobCards.[StartDate] = [StartDate]+6
WHERE (((Weekday(Weekday([StartDate])))=3));