A couple years ago Jesse Weaver came up with this report for active borrowers (i.e., patrons checking out materials): SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT borrowernumber) FROM old_issues LEFT JOIN borrowers USING (borrowernumber) GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode; I'm wondering if the caveat he notes is still true: Because it uses old_issues, it won't include anything that's still checked out; getting around that requires either ugly subqueries or running the report with old_issues and issues and manually combining the results. Is there a relatively easy way to modify the report so it includes patrons who may still have items checked out? Thanks for any assistance! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH "Politeness and consideration for others is like investing pennies and getting dollars back." Thomas Sowell