[AccessD] Sort By Sum on Footer

Thanks Susan...but I'm not sure I follow what you mean by 'invisible group'.

I still need to display the count values for each group...just need to sort 
on the sum of the counts for each group.

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: Fri, 11 Aug 2006 11:56:21 -0400
>
>Frankly, I think I'd just build an invisible group.
>
>Susan H.
>
>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?
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com