Having a difficult time writing a query

[AccessSHELL]

In Access 2003 on WIN10. I have a table with the following fields: ItemNbr, RecNbr, Desc. There are more fields, but not important for discussion. Each ItemNbr can have several RecNbr's. I need a query the displays one record for each unique ItemNbr. Other fields in results need to be Desc and MAX recNbr for the ItemNbr. The Desc field should contain the Desc from associated recNbr 1.



Thanks

[ranman256]

Q1: pull MAX(RecNum), itmNum

then Q2:
use Q1 to pull the full record by joining on RecNum.
select table.* from Q1,table where table.recNum=Q1.recNum

[AccessSHELL]

I wrote Q1 as:
"SELECT table.itmNbr, Max(table.RecordNum) AS MaxRecNbrFROM table
GROUP BY table.itmNbr
ORDER BY table.itmNbr "
I got what I expected. That worked great.

Can you expand Q2 for me?

[AccessSHELL]

I got it. It took a while to fully understand Q2.

Thanks