X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Sort On Volumes Per Group?, Access 2010    
post Jan 10 2017, 08:09 PM

Posts: 73
Joined: 4-July 11


I am using Access 2010. I am trying to create a report where I group by City but sort by the volumes per city. So if Toronto had 36, Montreal 48 and Moncton 24, I want to sort descending so the resulting order is Montreal, Toronto and Moncton.

I am grouping on city, creating a field of Count(ID_Number) and creating a sort expression for Count(ID_Number). I even tried grouping in a query and basing the report on that with the query doing the descending sort and it wouldn't work.

I am also miffed why the "with A on top" of the group is present suggesting to sort by city name but that makes no sense. I'm sure this may be easy and I'm missing something due to sleep deprivation. All assistance greatly appreciated.
Go to the top of the page

Posts in this topic

Custom Search
RSSSearch   Top   Lo-Fi    22nd April 2018 - 03:54 AM