<div>
Where [Week Ending] = date() - weekday(Date(), vbSaturday)<br />

</div>


Where [Week Ending] = date() - weekday(Date(), vbSaturday)


<div>
Fyed:<br />
<br />
My WHERE clause looks like this...<br />
<br />
WHERE ((CAR_Requests.Status)=&quot;Cl<wbr />osed&quot;) And Where([Closed Date]=date()-weekday(Date(<wbr />),vbSaturd<wbr />ay))<br />
<br />
I got an &quot;Undefined Function in WHERE Clause&quot; Error when trying to execute it. Did I do something wrong?<br />
<br />
Thanks
</div>


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

<div>
That worked! Thank you.<br />
<br />
Rex
</div>


<div>
<div class="content wysiwyg-content">
To make it easier, it already assigns a &quot;week ending&quot; date, so every record has a Saturday date. I just want to have the returns limited to the items with the date from &quot;last Saturday&quot;<br />
<br />
I will run this query any day from monday to Friday of &quot;This Week&quot;, but I always want it to ONLY show the results from last week.<br />
<br />
Does that make sense? thanks.
</div>
</div>


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.

How Can My Query Return Only Items With a Date from &quot;Last Week&quot;?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

How Can My Query Return Only Items With a Date from &quot;Last Week&quot;?

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