27 Oct
2009
27 Oct
'09
9:20 p.m.
2009/10/28 Melanie Hedgespeth <melanie@salpublib.org>
I need to create a report that lists the total number of holds placed for a month’s period. (Able to separate that by library)
Any tips on how I go about this?
Hi Melanie Something like SELECT count(*),branchcode FROM reserves WHERE reservedate >= '2009-09-01' AND reservedate <= '2009-09-30' GROUP BY branchcode Oughta work Chris