Trying to find the latest record

[charles.kendricks]

I have a table that holds customer examination records. I am trying to
come up with a query that would yield only the latest record for each
customer. Each customer has a unique CustID and each examination
record has a unique ExamNo. Each examination record contains both of
these fields (among) others. So that there can be many examinations
per customer. I want 1 record per customer, the one with the highest
ExamNo, since that would also be the latest. It seems like this should
be easy, but I am stumped

 

[Ron2006]

Two queries:

1) Group by query that is grouped by customer and contains examNo
(select Max for the examno)

2) Query 2 is a display query that then links all the rest of the
information you need in the table to the just defined query - linked by
examno.

 

[charles.kendricks]

I knew there had to be a simple solution, I just never thought to
utilize two seperate queries. Your method accomplishes exactly what I
wanted--Thanks a million