If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Choosing records to print based on latest revision
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! |
#2
|
|||
|
|||
Choosing records to print based on latest revision
"madmckenna" wrote in message
... 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 [table] 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 [table] ON [table].Procedure=[query].Procedure; This should return only the records for the maximum Rev for each Procedure. Carl Rapson |
Thread Tools | |
Display Modes | |
|
|