getting last week's values from a table

[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

 

[Nikos Yannacopoulos]

Nelson,

In your query, you need a criterion in the date diled like the following:

=Date()-Weekday(Date())-7 And <=Date()-Weekday(Date())

HTH,
Nikos

 

[Guest]

Thank you

-----Original Message-----
Nelson,

In your query, you need a criterion in the date diled like the following:


HTH,
Nikos




.