Awesome! Works like a charm.<br><br><div class="gmail_quote">On 4 March 2010 08:53, Chris Cormack <span dir="ltr"><<a href="mailto:chris@bigballofwax.co.nz">chris@bigballofwax.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
2010/3/4 Mark Osborne <<a href="mailto:mosborne@ashs.school.nz">mosborne@ashs.school.nz</a>>:<br>
<div class="im">> Hello,<br>
> Is there an easy way to see which of our patrons has written comments on<br>
> items in the OPAC and how many comments they have written? I'd like to see<br>
> who has done this and who our most active 'reviewers' are.<br>
> Thanks,<br>
><br>
</div>You could do this with some SQL in the reports module<br>
<br>
SELECT cardnumber,firstname,surname, count(reviewid) FROM borrowers,<br>
reviews WHERE reviews.borrowernumber = borrowers.borrowernumber GROUP<br>
BY cardnumber,firstname,surname<br>
<font color="#888888"><br>
Chris<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Hei konā mai,<br><br>Mark Osborne<br>Deputy Principal,<br>Albany Senior High School.<br>Google Map: <a href="http://bit.ly/7cchi3">http://bit.ly/7cchi3</a><br><a href="http://wikieducator.org/Albany_Senior_High_School">http://wikieducator.org/Albany_Senior_High_School</a><br>
<a href="http://wikieducator.org/Albany_Senior_High_School/ICTs">http://wikieducator.org/Albany_Senior_High_School/ICTs</a><br>