Need to have the Count sorted by highest number

[DougP]

I created a report having a Group and a count only, no details. the field is like so =Count([Mycolumn})
looks like so
Boards = 3
-------------
Circuits = 20
-------------
Pans = 14
-------------

I need it to have whatever number is higher at the top
Circuits = 20
-------------
Pans = 14
-------------
Boards = 3

When I try to add it to the Sorting and grouping I get the aggregate grouping error.
So how do I sort the unbound Count column.

DougP, MCP, A+

 

[THWatson]

DougP
You could do it this way.

1. Base your report on a totals query. In the query put a Group By column for MyColumn, and put an extra Count column that does a count of MyColumn (for purposes of example only, I'll call it Test, so the column's full name in the query would be Test:MyColumn).

2. In your report, have the first sort done on the Test field, Descending. Have a second sort done by the MyColumn field, with a Group Footer...since you are putting all the data in the footer.

If I understood what are doing correctly, that will work.

Tom