I designed a query to list data for a client for each month [claimdate]. A client may have multiple rows of data for the same [claimdate], however, I only want to list the [claimdate] with the largest revision number.
I have attached a spreadsheet depicting the information listed above. From my query, I highlighted two rows of data, with the same [claimdate] (10-31-2013). I only want to display or list the [claimdate] with the newest/greatest [RevisionNo].... in this example would be 1, however, client can have several revisions (2, 3, etc. )
FYI, a client can have multiple months with duplicate [claimdate] not shown in this example.
Your assistance is always greatly appreciated.