?
Solved

How Can My Query Return Only Items With a Date from "Last Week"?

Posted on 2011-09-28
4
Medium Priority
?
287 Views
Last Modified: 2012-05-12
To make it easier, it already assigns a "week ending" date, so every record has a Saturday date. I just want to have the returns limited to the items with the date from "last Saturday"

I will run this query any day from monday to Friday of "This Week", but I always want it to ONLY show the results from last week.

Does that make sense? thanks.
0
Comment
Question by:Rex85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 48

Expert Comment

by:Dale Fye
ID: 36719524
Where [Week Ending] = date() - weekday(Date(), vbSaturday)
0
 

Author Comment

by:Rex85
ID: 36719569
Fyed:

My WHERE clause looks like this...

WHERE ((CAR_Requests.Status)="Closed") And Where([Closed Date]=date()-weekday(Date(),vbSaturday))

I got an "Undefined Function in WHERE Clause" Error when trying to execute it. Did I do something wrong?

Thanks
0
 
LVL 48

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 36719582
Try:

WHERE CAR_Requests.Status="Closed"
And [Closed Date]=date()-weekday(Date(),7))

If this is in a query, you will probably have to replace vbSaturday with the numeric value of 7
0
 

Author Closing Comment

by:Rex85
ID: 36719623
That worked! Thank you.

Rex
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question