There were all kinds of problems with that edited report - here's the one that worked:
SELECT branchcode, categorycode, COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <<Date between (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> and branchcode = <<Branch|branches>> GROUP BY branchcode, categorycode ORDER BY branchcode Field names got a bit messed up and extra 'ands' and characters were wrong. Nicole _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
