Max Month Date 1

[markedback]

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.

 

[PWise]

Where month(invoicedate)= month(dateadd("m",-1,Date)) and year(invoicedate)= year(dateadd("m",-1,Date))

 

[PHV]

In the criteria cell of the date field:
Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[markedback]

Thanks PHV your criteria works perfectly!

pwise, I was looking for a solution like PHV suggested but thanks to you too for taking the time to help me.

Thanks,
Mark.