query current month

[Guest]

Hi,

How can I set up a query to show all orders that have due date in this month
and all previous months? I want to avoid prompting the parameter to user like
a form or parameter box. I expect the criteria in my query to know the
current month and run the query.
For example
<=now() then this only give me everything up to the current date & time.
I want to see everything up to 1/31/05. Is this possible?

Thanks
Ashley

 

[Ken Snell [MVP]]

Use this as the criterion (assumes you're not needing the time as well):

<= DateSerial(Year(Date()), Month(Date()) + 1, 0)