Sorry this is probably more complex that stated. Here is my code for the current query. This displays all records in the database for completed training. In this example the results are for one employee and for all of the training they have completed. I need to limit each the results to the most recent of every one of the trainings (SOP Number) completed.
SELECT [Main TBL].[Employee Number], [Main TBL].DateCompleted, [Main TBL].[SOP Number], Format([Main TBL]![SOPVersion],"""-v""00") AS SOPVersion, [SOP TBL].Description, [SOP TBL].Type, [Employee TBL].[Last Name], [Employee TBL].[First Name], [SOP TBL].Expiration, [Employee TBL].Inactive, SOPVersionTBL.Obsolete
FROM ([SOP TBL] INNER JOIN ([Employee TBL] INNER JOIN [Main TBL] ON [Employee TBL].[Employee Number] = [Main TBL].[Employee Number]) ON [SOP TBL].[SOP Number] = [Main TBL].[SOP Number]) INNER JOIN SOPVersionTBL ON (SOPVersionTBL.SOPVersion = [Main TBL].SOPVersion) AND ([Main TBL].[SOP Number] = SOPVersionTBL.[SOP Number]) AND ([SOP TBL].[SOP Number] = SOPVersionTBL.[SOP Number])
WHERE ((([Main TBL].[Employee Number])=[Forms]![Employee Name Parameter FRM]![LastName]) AND (([Employee TBL].Inactive)=False) AND ((SOPVersionTBL.Obsolete)=False));
