Latest Date 1

[magnys]

I've got a database that is detailed instructions for my assembly operators. There is a table in the database that is a "revision" table. Anytime I make a revision to an individual operator I enter the date that revision was made, a description of the change, and print out a hard copy of the updated instructions. As an operator goes through several different revisions, I have multiple dates for the operator. Is there a way that I can pull the latest date for each operator from the revision table for display in the operator instructions report?

Thanks for any help.

Magnys

 

[grande]

Maybe you could try something like this:

SELECT tblInstructions.Instructions, Max(tblInstructions.Date) AS MaxOfDate
FROM tblInstructions
GROUP BY tblInstructions.Instructions;

Hope this helps!

 

[magnys]

Perfect!

Much Thanks