Query Help to View Most Current Log On Date

J

John

I have a working query; however, I am unable to get it to return the most recent log in date (ISONLINE_ONLINE_LOG.LOGDATE) when I enter a person number. Does anyone have any suggestions? I'd really appreciate the help. Thank you

SELECT Pub_All_Users_Appusers.LNAME, Pub_All_Users_Appusers.FNAME, Pub_All_Users_Appusers.USERNAME, Pub_All_Users_Appusers.PERSON_NUMBER, Pub_All_Users_Appusers.CREATED, Max(ISONLINE_ONLINE_LOG.LOGDATE) AS MaxOfLOGDAT
FROM ISONLINE_ONLINE_LOG INNER JOIN Pub_All_Users_Appusers ON ISONLINE_ONLINE_LOG.UNAME = Pub_All_Users_Appusers.USERNAM
GROUP BY Pub_All_Users_Appusers.LNAME, Pub_All_Users_Appusers.FNAME, Pub_All_Users_Appusers.USERNAME, Pub_All_Users_Appusers.PERSON_NUMBER, Pub_All_Users_Appusers.CREATE
HAVING (((Pub_All_Users_Appusers.PERSON_NUMBER)="12345678"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query 2
Please Help! 4
Query to Pull Most Recent Call with a Callback Date Scheduled 10
Select only most recent payment 2
return fields associated with max value record 9
Copy previous record into form field 0
Query to select individual records 4
Hide dupes in a query 3

Top