Query for things happening this week

[Laurie]

Hello--

I have a table with a date that tells me when a student's suspension is
ending. How can I write a query that will tell me which suspensions are
ending this week and next week automatically, without me having to update the
dates in the query every week?

Thanks, as always, for the invaluable assistance of everyone on here.

 

[KARL DEWEY]

Criteria --
Between DateAdd("d", -Weekday(Date())+1, Date()) AND DateAdd("d",
-Weekday(Date()) +14, Date())

 

[Laurie]

Thanks so much, perfect!

Criteria --
Between DateAdd("d", -Weekday(Date())+1, Date()) AND DateAdd("d",
-Weekday(Date()) +14, Date())