Date Manupulation

[Guest]

I have a date field on my Form which will show the next days date like this

If Today is Monday(Jan 01,2004), then my field wil show tommorrow's date(Jan 02, 2004

and if Today is Friday(Jan 05, 2004) then my field will show Monday's date (Jan 08, 2004

Can anyone help?? thanks....

 

[John Spencer (MVP)]

Is this a query question?

Select DateAdd("d",IIF (WeekDay(DateField)
=6,3,IIF(Weekday(DateField)=7,2,1),DateField) as Tomorrow
....

Or

Select DateAdd("d",Choose(Weekday(DateField),1,1,1,1,1,3,2),DateField)
....