Set criteria in a query to always find current month data

[Sharon N]

I have reports that list the All Invoices for the "Current Month" & another
for "Last Month". With the "Last Month" Query I have the date parameter
recorded in the criteria of the Query (eg Between #01/02/06# and #28/02/06#)
but I have to update this at the start of every month. Is there a formula
that will do this automatically so I don't have to change it each month?

 

[Ricky Hicks [MVP]]

Try using the following as your criteria ...

Between DateSerial(Year(Date()),Month(Date())-1,1) And
DateSerial(Year(Date()),Month(Date()),0)

 

[Sharon N]

Hi
Worked perfectly
Thankyou - very much appreciated

Sharon N

 

[kaltman]

More than two years later, your assistance is being gratefully and
successfully used. Thank you.

 

[bfields810]

7 Years Later

Still helpful info