Querying for Records From Today till One Week Ago

[landerson]

Hello. I want to create a query that will return all records that were entered from today to 7 days ago. I have a DateEntered field on my table that stores the date information and I have been playing around with what I entered in the criteria there, but nothing seems to be working. I was trying to use the DateAdd function but with negative numbers, but I am doing something wrong.

Thank you in advance to any assistance that could be provided.

 

[justchillin]

Have you tried this in the criteria field

between[Enter Date 1 ]and[Enter Date 2]

This will display 2 input boxes prompting the user to enter the required dates

Where date 1 is todays date and date 2 is 7 days prevoius,

 

[raskew]

Or perhaps: >= date() - 7

Bob