Mighht give you an idea?Code:SELECT tblRobDog.PO, tblRobDog.dDate, Weekday([dDate],2) AS [TheWeekday], [dDate]+(8-Weekday([dDate],2)) AS [NextMonday] FROM tblRobDog;
Vince
|
Results 1 to 5 of 5
Threaded View
|
Click Here to Expand Forum to Full Width |