Sort By Count

[Guest]

I am using MS Access 2003.

My database consists of anglers(fishermen) and their catches. My query
produces a list of anglers and the date and time and weight of each fish
caught by that angler. I want to produce 2 reports: summary & detail. I can
produce both reports but I am unable to produce them in descending order by
"total count" for each fisherman. I've manipulated the sorting & grouping
section in the report, but am unable to get the results I want. I'm sure
there is a simple solution, but I cannot seem to find it. Can the query hold
the count for each fisherman or is the count only in the report? Please help.

 

[Allen Browne]

If you want the report sorted by the total, your query must supply the total
to the report. (The report can't sort by the total if it has not calculated
the totals until after it lays all the records out.)

One way to do this would be to create a Totals query that gives the count,
save the query, and then use it as an input "table" for the next query that
contains the detail.

Another approach would be to create the Totals query as use it as the source
for your main report. Then use a subreport to list the details.

 

[Guest]

Hi Allen:

Thanks for your solution. I used, "One way to do this would be to create a
Totals query that gives the count, save the query, and then use it as an
input "table" for the next query that contains the detail."

Dan