On 17 June 2010 07:33, Susan O'Neal <soneal@mtpl.org> wrote:

Hi Chris- nice to hear from you and so quickly!  See the attached Excel spreadsheet for how I would like to organize, and, if possible, retrieve the information.  I do not wish to know the specific titles or call numbers at this point just the total numbers.  The I'll compute the average age of the collection.   I've been frustrated in Koha report by not being able to figure out how to collect 3 units of data in the same report. Does that make sense?  My SQL ability is pretty limited to cut and paste ............

Branch Collection Date [range]

Ok, would itemtype work instead of collection (one less table to join) and do you use item level itemtypes? And can you check your koha2marc mappings and see what field (if any) 260c is linked to? Chris