Re: [Koha] Help with sql statement.

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