Query for things happening this week

  • Thread starter Thread starter Laurie
  • Start date Start date
L

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.
 
Criteria --
Between DateAdd("d", -Weekday(Date())+1, Date()) AND DateAdd("d",
-Weekday(Date()) +14, Date())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Date Between Start and End 2
SUM in a UNION query 2
Multiple queries in report 2
Help with generating week dates for a table. 2
Need Monday date for given week number 4
group by name having 2 different groups ( weeks ) 10
Querying Dates 5
Need Sum of Weeks Between 2 Dates 1

Back
Top