9 Jun
2012
9 Jun
'12
6:24 p.m.
Hello everyone, I am trying to get the new patron report developed by Sharon Moreland, to do a date range and have a location selection for San Benito County Free Library. I am sure I am doing something wrong, please advise as necessary, SQL: SELECT b.code,c.code,COUNT(*) FROM borrowers WHERE DATE(dateenrolled) between <<Date between (yyyy-mm-dd)>> AND DATE(dateenrolled)= <<and (yyyy-mm-dd)>> and b.code=<<Pick your branch|branches>> GROUP BY c.code Thank you for your patience and understanding, James Ghiorzi Data Management Coordinator Martin Luther King Jr. Library San Jose State University