getting last week's values from a table

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

Hello,

I would like to run a query that will give me the entries
of a table from the previous week. The entry_date is in
the format of a simple date (ie., mm/dd/yyyy).

I want all the entries from Sunday to Saturday. Ex, let's
say today is Jan.16, the entries returned will be from
Dec.04 to Dec. 10. It doesn't matter what day of the
week I run this query, I always want the data from the
previous week.

Any help will be appreciated. Thank you in advance
 
Nelson,

In your query, you need a criterion in the date diled like the following:
=Date()-Weekday(Date())-7 And <=Date()-Weekday(Date())
Click to expand...

HTH,
Nikos
 
Back
Top