I am currently using between [Enter Start Date] and [Enter End Date] as criteria on a query. This makes it ask for the start date and end date. The problem is, this is a base query for 4 different queries for 4 different dates. What I actually need is "last month" (September, not last 30 days), "Year to the end of last month", "September of last year", and "Last year to the end of September". I can't find the date command to filter the information the way I need it without using the [Enter Start Date]...
Help
Help
