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

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

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
 
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.
 
Back
Top