markedback
MIS
I am trying to automate the entry of a date range in a query.
One of my co-workers has to run a query for a report showing details of last month's sales at various times in the current month.
He has to enter the date of first day and last day of the previous month everytime in the parameter prompts.
Is there a way to eliminate this by having the criteria in the date field lookup the date range between the minimum and the maximum dates of the previous month?
Thanks,
Mark.