Calculate number of entries by year and frequency (1 Viewer)

Hi, am sure this is simple....! Can't find a solution.

I have records which have YEAR and APPARATUS as two of the fields. All I want to do is write a query which displays all the records chronologically by YEAR then within each YEAR to group them by the biggest subset according to APPARARTUS.

Therefore if there were 20 people who used Motorised equipment, 15 who used electrical and 10 who used gas, the records would be grouped in that order. Thus showing the pattern in change in use of specific apparatus over the years.

Why can't I DO THIS!!??

aLI

Because your not using a "group by" query ?

Hi, sadly I am using GROUP BY. It orders by year fine, it groups by apparatus within each year fine but NOT in order of most prevalent group, just in alphabetical order! Does thqt make sense?!

Yeah that makes sence, and thats the way a group by works.

You simple need to add the sort order... Just look up the Sort: line in the query design and order the result any way you see fit.

Good Luck