I haven't been able to get Karl's approach to work. My database holds records
from all years. In the Cost of Quality (CoQ) table, one record = one month.
We date the month 9/1/09, 10/1/09, and so on. I just want to call up the
number of complaints (total number) from the Complaints table that match the
COQ Table's current record (current month). With Karl's approach, I can
remove the "[Forms]![frm852COQ]![Month] and get all the complaints in the
table (total). With that criteria I get zero. I need to find the right date
field/format that matches the complaint table's september (09) results for
example. [The current record could be 8/1/09 in the CoQ table - which means I
want to find the total number of complaints in the complaints table for
August 09.]

Hope this explains it better and thanks.



"Jeff Boyce" wrote:

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.