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