[AccessD] Sort By Sum on Footer

So, you're sorting pages? 

Susan H. 

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?