Reverse Sequence of Numbers

[OpsO]

I think the best way for me to ask the question is to explain the scenerio. Data is linked to an external source. Each time an event occurs (like a payday lets say), a new record is created and it is assigned a sequence number. (For argument sake, there is no set day or date that payday falls on.) Someone paid by the company two times would have two records, the first payday would be sequence # 1 and the second payday sequence # 2. Someone with the company multiple years could have 100 records or more. I am trying to isolate the highest sequence number for each employee. The highest number would indicate the latest event. I have utilized other software in the past and used a rank function which would reverse the numbers and then I could just filter for sequence = 1. Is there a way for me to do this in access.



Thanks in advance for any help

[NTC]

there's several ways to approach it... one simple way is to make a query; use a person's name/ID as criteria - so that you are looking at only 1 person's records set....and then in the sequence column just set the sort to be descending....

or you could use an aggregate query, look for the epsilon E symbol in query design; set it to group on the name and then the sequence column set that to Max.