Sort On Volumes Per Group?, Access 2010
Jan 10 2017, 08:09 PM
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.
|Search Top Lo-Fi||28th February 2017 - 09:52 AM|