On Mon, 21 Sep 2009 08:51:02 -0700, Bob Waggoner
wrote:

John,
Thank you for your reply. When I add = DateSerial(Year(Date()),
Month(Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 1, 1)

to the criteria under Expr2 (BELOW) which is: MaxofDateDone + freqDays I get
a list of pms due in September.

That's what you asked for, so that's the question I answered:

In a calibration database I have a query that calculates due dates. I'd like
to limit the query to just the calibrations due in the current month. How do
I modify this formula to make only the current month's due dates show up?

How do I get PMs that might be overdue (from
august) as well?

I don't know, because I don't know the structure of your database nor how you
determine that a record is overdue. Perhaps just leave off the first date
criterion if you want all records in September *or earlier*.
--

John W. Vinson [MVP]