Hi i have two tables which my website connects to:
When someone logs in to the website, their username and login date is entered into the tbl_Login table. What i would like to do is create a Query which displays all fields from tbl_Clients and only the more recent LoginDate from the tbl_login table. Is this achievable in the query design?
thanks for the link. I did something very similar. I created an additional query for the login and grouped by the Max values. Then I used my master query which pulled in each individual last login attempt for each user.