Call Last record in Table using Access VBA

[anwaar]

Guys,

Can anyone help me out, I have a login form programmed in Access VBA which take username and password, match it with original values (username, password) and store both of them along with login date/time in a seprate table named as "LoginAttempts". Now the problem is, I want to call the last record of "LoginAttempts" table (username of last user who log in) in another form.

Please help me out to make it possible??

[eww]

I think there are a few different ways you could go about doing this, my choice would be to create a small query for the form you want, pulling the username and max date/time out of the table:

SELECT username, Max(datetime) FROM table GROUP BY username;

[anwaar]

Thanks Eric,

I have try to call Maximum LoginDate but when I run the query it ask me for LoginDate Perameter. I mean It should autometically pick Maximum LoginDate from table??

[eww]

Sorry, this one was a little trickier than I originally thought. Not sure what was the parameter issue you were having, but this might fix it anyway. The correct query you want to use would be:

SELECT LoginDate, Username FROM yourtable WHERE LoginDate IN (SELECT Max(LoginDate) FROM yourtable);

With the first one you would have got the latest LoginDate for each user, and I'm assuming you want the latest user's login.

[anwaar]

Thanks Eric,

Both of your examples really help me to get my required results