WOW, Thanks for the quick response John, that does a great job of getting down to just the greatest date. Guessing I need to be more articulate... I'm looking for the greatest date (with your suggestion) by employee id (License_Cert.[Emp#]) if that makes since.
The data looks like:
ID Cert_Expire_Date Cert_Title
0284 05/12/2011 Scissor Lift Cert
0284 02/11/2012 Scissor Lift Cert
0284 07/22/2014 Scissor Lift Cert
0284 01/08/2015 Scissor Lift Cert
0742 01/14/2011 Scissor Lift Cert
0742 07/28/2014 Scissor Lift Cert
0742 11/17/2015 Scissor Lift Cert
I have been playing with your suggestion but can't figure out how to get the latest date for each employee ID.
Sorry for not being more precise in my first explanation!
Posted by: email@example.com
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|