Query for find latest, need HELP!

[marubal21]

Hi,
I have a table with login info, and i'm trying to find the latest login per account.
table Ex.

AccNum UserID Login_Time

123 m 7/19/2010
123 v 7/20/2010
111 a 1/2/2010
222 q 7/20/2010
333 b 7/1/2010
777 c 1/2/2010
123 c 7/18/2010
999 m 6/30/2010
222 q 6/30/2010
222 d 7/1/2010

the system allows multiple users per account, i'm trying to get just the most latest login per account. example how i expect results to look below.


AccNum UserID Login_Time

123 v 7/20/2010
111 a 1/2/2010
222 q 7/20/2010
333 b 7/1/2010
777 c 1/2/2010
999 m 6/30/2010

as you see i expect on to have the latest from the account with multiple logins, if you could help i thank you in advance.

 

[pbaldy]

This type of thing?

http://www.baldyweb.com/LastValue.htm

 

[marubal21]

that seem like it could work, i'll try it out on access when i get a chance and let you know how it turns out. thanks

 

[pbaldy]

No problemo.