Bob

That will depend ... (doesn't it always!G)

If your table holds ONLY a single year's records (NOTE: not recommended!),
then finding "September"'s records is easy to handle several different ways,
including the approach Karl offers.

If your table holds many years' records, do you REALLY want to see (all)
Septembers' records, or only for a particular year?

"How" depends on "what"...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

"Bob Waggoner" wrote in message
...
How do I limit the records in a query to a certain month? Example: I want
to
know how many records (count) there are in a table for the month of
September
2009 from one table - but use the date on a form from another table.

Table 1: Complaints Table 2: CostOfQuality
Table 1: Date Field: "ComplaintDate" Table 2: Date Field: "Month" (always
entered as the first day of the month like 9/1/09.)

Form: frm852COQ

The report uses Table2 as the record source (the current record on
frm852COQ)
I need to total the number of complaints from table 1 for the current
month
and display the count on the report.

Any help is appreciated. Thanks.