Set criteria in a query to always find current month data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try using the following as your criteria ...

Between DateSerial(Year(Date()),Month(Date())-1,1) And
DateSerial(Year(Date()),Month(Date()),0)
 
More than two years later, your assistance is being gratefully and
successfully used. Thank you.
 
Back
Top