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!



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:

Posting Komentar