[Koha] Help with sql statement.

[Nicole Engard]

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