How to add # of days to a parameter that returns a date?

[Bill Reed via AccessMonster.com]

Here's the query:

SELECT CalendarDay
FROM tblCalendar
WHERE CalendarDay>=[Enter Date] AND CalendarDay<[Enter Date]+7 AND Weekday=1

I'm trying to get the next Sunday after the date entered into the
parameter, "[Enter Date]", without requiring the user to input 2 dates. Can
anyone help me with a workable way to implement the above logic?

Thanks,

Bill

 

[Marshall Barton]

Here's the query:

SELECT CalendarDay
FROM tblCalendar
WHERE CalendarDay>=[Enter Date] AND CalendarDay<[Enter Date]+7 AND Weekday=1

I'm trying to get the next Sunday after the date entered into the
parameter, "[Enter Date]", without requiring the user to input 2 dates. Can
anyone help me with a workable way to implement the above logic?

That should be something like this (air code)

AND CalendarDay < DateAdd("d",7 - WeekDay([Enter Date], 2),
[Enter Date])

 

[Bill Reed via AccessMonster.com]

Thank you Marshall! All donations are gratefully accepted.

Bill