Query to select rows that are the MAX of one column but unique on another

[cbmorehouse]

I'm trying to explain what i'm needing in the best way possible. I've attached a spreadsheet with results from a query I have. I'm wanting to only see the most recent record for each highlighted area based on the "revisionnumber" column. For example, the yellow highlighted rows only need to show line 3. For the green highlighted rows I only want to see row 6; blue rows....row 10; and orange rows....row 13. I've tried grouping all of the columns then putting MAX for the revisionnumber column, but that didn't work. I'm also going to attach the SQL of the query. Any help is appreciated!

[ranman256]

you need 2 quieries...1 for max, 2nd for all other data
Q1, get the max:
select ID, MAX(revNum)

then Q2 to get all your data using Q1:
select * from table, Q1 where table.ID = Q1.ID

[cbmorehouse]

I'm confused. Am I supposed to just create Q1 with only the ID and the MAX(revNUM)? Then you say to create another query that is selecting the data from Q1. What's the purpose of creating another query to select only two fields that make up Q1?