Select records created last week

[barra47]

I need to write a query to filter records that were created in the previous week, can you please help me with this one, Thanks in advance

Each record has an OpenDate field.

 

[dhookom]

SELECT *
FROM tblNoNameGiven
WHERE OpenDate Between Date()-7 and Date();

Duane
Hook'D on Access
MS Access MVP

 

[PWise]

Duane:

Your code will return the last seven days

the previous week Can be more then seven days ago

Try:

SELECT * 
FROM tblNoNameGiven
WHERE Daterpart("ww",OpenDate)=DatePart("ww",Date())-1;

P.S. You still have to adept for the last week of a year.

 

[dhookom]

I guess this depends on how you interpret "previous week". I consider a week as 7 days. Perhaps barra47 can suggest what is desired.

Duane
Hook'D on Access
MS Access MVP