Hi, As per our Library reporting requirements, I have just prepared SQL on "Library Books investments by Collection Code". I thought of sharing it, because it is useful for Engineering College Libraries in India for AICTE reports preparation. I did not find it in SQL Library and if somebody is already added, kindly share the sql link. ------------------------- SELECT ccode AS Collection Code, COUNT(DISTINCT items.biblionumber) AS 'No of Titles', COUNT(itemnumber) AS 'No of Volumes', SUM(price) AS 'Investment or total expenditure' FROM items GROUP BY ccode ---------------------------- Result: Collection | No of Titles | No of Volumes | Investment or Price CSE | 305 | 2110 | 994267.50 With Thanks Satish MV Librarian Govt. Engineering College, Hassan Karnataka www.gechassan.ac.in --