Request between week ending date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently using a query that request a "start date" and an "end date", I
would like to change the request to "Week ending date" and include
information 7 day back. What would I have to change to get this information?
 
In the Criteria row under your date field, you currently have:
Between [start date] And [end date]

Try:
Between [week ending date] - 6 And [week ending date]

It is always a good idea to declare date parameters.
In query design view, choose Parameters on the Query menu.
Enter into the dialog:
[week ending date] Date/Time
 

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

The query cannot be completed. 1
Weekly crosstab query 8
Querying Dates 5
Need Sum of Weeks Between 2 Dates 1
Date Range - Between Start and End 5
How to append query w/lookup fields.... 2
Parameter Query 8
Between date with greater than or eaqual to 4

Back
Top