How can I do this? sort by month, year and highest value?

[Dave Elliott]

how can i show via a query all the platforms by month and year where
additional sample is the highest value?
example: Platform is named Bubba, Month is September, year is 2004 and sort
by additional sample highest value, then next highest value???

Table has these fields;
platform text
month text
additional sample number
year text

 

[Rick B]

Put the fields in the order in which you wish to sort them (Year, then
Month, then AdditionalSample).

Then use the "sort" drop down under each field and set it to ascending or
descending.