Ciao, Andrea. Maybe SELECT DISTINCT(biblionumber), count(biblionumber) FROM items GROUP BY biblionumber HAVING count(biblionumber) > 1 can help you. sb

I'd need to write a report for finding records with multiple items in them: any suggestions? TIA

Andrea Furin