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.
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.