Access 2007 query question

[teachesms]

I am at a loss this morning.

In a query how do I write the statement :

I am looking in a field that a request for something has been sent. I want to look up anything between the current date =NOW() and what has been requested during the last 7 days .

Something like BETWEEN (=NOW() and anything requested during the last 7 days)

no matter how I write it it doesn't happen.

one of those days.

thanks for looking at this and any advise!

[HansV]

Try

Between Date()-7 And Date()

[teachesms]

ah...thank you Hans. makes sense!

:)

[HansV]

One thing to keep in mind: Between includes the lower and upper bounds. So if you want to select requests that have been sent less than 7 days ago, use

Between Date()-6 And Date()

[Wendell]

Adding to Hans' caution - if you use Now() to populate the field you need to be aware that it includes the time as well as the date. Thus if you use Date() in your criteria, you may miss a record entered today.