create query to display data entered in the last 7 days

J

jam7843

Hi all

I'm try in to create a query to display data entered on a weekly basis
What expression is used in the Criteria field. Can anyone help
 
J

John Vinson

Hi all

I'm try in to create a query to display data entered on a weekly basis.
What expression is used in the Criteria field. Can anyone help?
Click to expand...

Depends entirely on how your table is structured, and how (or whether)
you record the date entered. If you have a Date/Time field in the
table with a Default property of Date() - for the date entered - or
Now() - for the exact date and time entered - you can use a criterion
of

BETWEEN DateAdd("d", -7, Date()) AND Date()

to get all entries up to the end of yesterday (midnight last night to
be exact).

If you don't record the date the record was entered you're out of
luck, because Access does not do so on its own.

John W. Vinson[MVP]
 
Top