Jumat, 29 Januari 2016

[MS_AccessPros] Re: Query the most recent date!

 

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!
Regards, Rohn

__._,_.___

Posted by: reverson@maintainer.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar