10 Feb
2011
10 Feb
'11
8:41 a.m.
Thank you, Bev! Seems to work fine for our small library. The only improvement would be to be able to specify a date range, the syntax for which isn't immediately obvious to me. Thank you again, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH On Wed, Feb 9, 2011 at 4:48 PM, Church, Beverly <bchurch@liblime.com> wrote:
select borrowers.surname, borrowers.firstname, borrowers.cardnumber, borrowers.categorycode, borrowers.dateexpiry from statistics, borrowers where statistics.borrowernumber = borrowers.borrowernumber and statistics.type = 'issue' group by statistics.borrowernumber having max(date(datetime)) >= 'YYYY-MM-DD' order by borrowers.surname, borrowers.firstname