Respected All I have gone through the previously posted messages on “ Report Generation- Till Reconciliation for each branch libraries” by Mr. Basu on *Wed, Dec 10, 2008 at 10:31 AM* and also read the views of Joe Atzberger , BWS Johnson, Joshua Ferraro and Henri-Damien I am sure that the each and every public library in India would like to know about how much money they have collected at the end of the day from their all category of patrons. Is it possible to generate the same Till Reconciliation Report with *Total amount paid* through *Home › Reports › Guided Reports Wizard › Create from SQL* . If yes, Please share the SQL Command. -------Advance Technology News for elibrarians http://sandeepbhavsar.blogspot.com/ ------ Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar@gmail.com Mob : 9987049099 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@