Hi and thanks for reading.

I need to create a report that displays the number of instances of records that fall into a specific catagory by month. I have found i can do a dcount (=DCount("TypeID","tblFile","[TypeID] = 3 AND [Opened] > #02/01/05# AND [Opened] < #02/28/05#")) in the control source of text boxes with the report bound to the table but would be static by year. Any ideas?

Thanks again.