Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    3

    Unanswered: retrieving last login date

    Hi i have two tables which my website connects to:

    tbl_Client
    ClientID
    Name
    Username
    Password

    tbl_Login
    LoginID
    Username
    LoginDate

    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?

    Cheers,

    reptar

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    This is not exactly on point, but perhaps gets you on the right track?

    Most recent value
    Paul

  3. #3
    Join Date
    May 2009
    Posts
    3
    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.

    Thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •