Sorting on group sum

[gradygoose]

I have found several things on the internet on how to do this but have not been able to make it happen. I have a simple task tracking database with 3 tables. There is an input form with a sub-form. I have a report that groups “Drivers” (just the buckets for grouping the tasks) and uses a simple formula to create a sum calculation for each group. I have attached a screen shot of that report. I want to be able to sort this based on the totals shown. I have read several things that indicate I need to create a totals query and then a report from that but have not been able to make that work. Thank you in advance for any suggestions.

[ranman256]

create a base query to pull all the data between the 2 dates on the form.
Then make queries on that query to get your results shown above.