Dear Friends, Can you help me to write an SQL query to prepare a report for items check in a particular day. Following elements likely to be include in the report, Patron Number, Name, Author, Title of the book etc Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in http://linuxhalwa.blogspot.com --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White