Austenr and OBP, Thanks to you both for answering. I am sorry it took me so long to respond. I found a report that solved my problem by using a query to first calculate my totals and then sort the report by query totals. I do not think I just explained the answer to well.
This is a great site - keep up the good work!