I am using the SQL report below for generating Total Fine Paid: SELECT accountlines.Date,borrowers.Cardnumber,borrowers.surname AS

"Students Name", borrowers.firstname AS "First Name", accountlines.Amount As "Paid Amount" FROM accountlines, borrowers WHERE borrowers.borrowernumber = accountlines.borrowernumber AND accounttype = 'pay' AND date BETWEEN <<Between Date (YYYY-DD-MM)|date>> AND <<and (yyyy-dd-mm)|date>> AND borrowers.branchcode=<<branchcode|branches>> ORDER BY accountlines.Date

Is it possible to add the shelving location? We use the shelving location as library sections and we want to determine the paid fines per library section. Thanks. -- Ma. Victoria H. Silva-Manuel Registered Librarian, 3892