Set criteria in a query to always find current month data


S

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?
 
Ad

Advertisements

R

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)
 
K

kaltman

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top