Choosing records to print based on latest revision

[madmckenna]

I have a training matrix that has the following fields:
Procedure
Employee
Rev
Date trained

There can be multiple revisions for the same procedure. I would like to
print a report by procedure that only shows the latest rev number. How would
I do this?

Thanks!

 

[Carl Rapson]

I have a training matrix that has the following fields:
Procedure
Employee
Rev
Date trained

There can be multiple revisions for the same procedure. I would like to
print a report by procedure that only shows the latest rev number. How
would
I do this?

Thanks!

When I've done is to create a query that returns the max Rev value, such as:

SELECT Procedure,Max(Rev)
FROM

GROUP BY Procedure;

Then I create a second query that returns all fields:

SELECT query.Procedure,table.Employee,query.Rev,table.[Date trained]
FROM [query] LEFT JOIN

ON

.Procedure=[query].Procedure;

This should return only the records for the maximum Rev for each Procedure.

Carl Rapson