[AccessD] Sort By Sum on Footer

Sorry...Here's an example:
NAME   COUNT
Bob        23
Bob        14
Mary       10
Mary       40


Each name has a footer that has Sum(count)...What is the easiest way to sort 
on this sum in the footer...so Mary's group would be listed first if sorting 
descending?

Thanks,

Mark


>From: "Susan Harkins" <ssharkins at setel.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Sort By Sum on Footer
>Date: Thu, 10 Aug 2006 19:03:09 -0400
>
>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?
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com