Sorry, it looks like i have a syntax error in my sql statement, please change it to:
SELECT recordNumber, date, fName, lName, telNo, apptTime, lenghtAppt, fee, comm, comments, SUM(fee) as Tfee, SUM(comm) as Tcomm FROM thenumbers ORDER BY date DESC
You could see that i removed a comma before "FROM"