Hi Chris Thank you! I did have a quick glance at those reports but obviously not close enough as I have now seen there is a report I can tweak to fit what I need. You (and anyone else) will always be welcome to visit our school in Switzerland, we are located on the shores of Lake Geneva and not too far from Porte de Soleil, the biggest ski resort in Europe (ok, I've done my bit for the Swiss Tourist Board now:-) Kind regards Lisa -----Original Message----- From: Chris Cormack [mailto:chris@bigballofwax.co.nz] Sent: 09 February 2011 22:24 To: Peel Lisa Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Help with report 2011/2/10 Peel Lisa <lisa.peel@ritz.edu>:

Hello

Apologies for showing my complete ignorance of sql but I need to create a report which lists catalogue records between two specific call numbers (for example, 641.5 to 641.6) – I need it to list author, title, edition and call number.

Is there anything I can follow on the report wizard which will help me create this report or is anyone kind enough to give me the sql which would create this report?

Hi Lisa Have you had a look here http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliograp... Hopefully there is a report there that fits your needs, if not, sing out and when I get a chance i'll write something up. All I ask in return, is a guided tour of the culinary arts school, should I ever visit Switzeraland again :) Chris