Query with MAX function on more than one field

[gmore24]

Hi! I am trying to figure out how to build a query on how to obtain
the following based on the data below for the following fileds.

ITM
SHP
LINE

I want to have the line where it's the max and after that the max
SHIPMENT_NUM.

PO | ITM | SHP | LINE
67 | 1 | 1 | 2
78 | 1 | 2 | 5
78 | 1 | 1 | 5

I already have a query that obtains the very last PO date for each
ITM. I used a group by expression in order to get these lines, but how
to obtain the MAX line only with the max SHP based on that line only?

In this case it should be 78 | 1 | 2 | 5.

Thanks for your help!!!
g

 

[Allen Browne]

See:
Getting a related field from a GroupBy (total) query
at:
http://www.mvps.org/access/queries/qry0020.htm

The article gives you 4 ways to select the desired record. Once you have
that, you can join that back to your original data to get the other fields
in that row.