Jumat, 29 Januari 2016

[MS_AccessPros] Re: Query the most recent date!

 

Tried adding to the WHERE:


(SELECT MAX(Cert_Expire_Date) and MAX([EMP#])  FROM License_Cert As L2 WHERE L2.[EMP#] = dbo_EMPLOYEE.ID)

Found another way NOT to get the results I am looking for!

Rohn

__._,_.___

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

.

__,_._,___

Tidak ada komentar:

Poskan Komentar