Date Problem

[scottappleford]

Hi

I am trying to create a query that when run will automatically take todays date and include the last 7 days into account.

It is for stock received in the last 7 days.

I have done a search but still a little copnfused.

Many Thanks

 

[pbaldy]

Try

Between (Date() - 7) And Date()