[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)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___