Criteria for date query

wayney2507

New member
Local time
Today, 00:18
Joined
Apr 29, 2009
Messages
9
Just wana search a table by the "Date" field for the last 7 days. When I open the report based on the query, it will show the last 7 days of records, without having to keep editing the criteria.

Criteria: "Between Date()-1 and Date()-7"

This works perfectly, but I'm, just wondering if there's a more professional criteria entry.
_________________________________________________

Then I want another query for the month. So that, for example, If i open the report for this any day in december, it will show all records in november. Then when it gets to January, it shows all records in december. etc etc.

Not sure what the criteria would be. Something like Month -1

Any help appreciated.
 
Wayne.

I think you've got it. I am attaching a link that has a tutorial on creating a small form that will allow you to select which report you want to run. I think it will be helpful to you.

http://www.fontstuff.com/access/acctut19.htm
 
Parameter Queries used instead.
 

Users who are viewing this thread

Back
Top Bottom