[AccessD] Sort By Sum on Footer

Hello All,

Other than creating a query that gets the sum and join it to the query I'm 
using as a recordsource...Is there a way to sort by the sum on a footer in a 
report...sorting/grouping doesn't seem to like the idea...any ideas?

Thanks,

Mark A. Matte