Query Expression to return only the latest data

[Brinleigh217]

I am needing to put in an expression into my query to pull the data for the latest date.


To explain further:
I have a table that has a username, password, and date of password (meaning when the password became active). I want a query to pull only the most recent password for each user, no duplicate usernames.

Can anyone help me? I have not been able to figure it out.

Thanks,

Leigh

[pbaldy]

Does this help?

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

[Brinleigh217]

I'm using 2010, where do I put in this code? I'm use to just building a query using the table layout at the bottom of the screen. I'm new to building databases. Can you explain this solution usage to me?

[pbaldy]

That is SQL, which you can put into SQL view of a query. It can also be done in design view, using the Totals icon.

[Brinleigh217]

Ok, thanks. Now my next question. I have Three Fields:

Password
Password Start Date
Login

From following the instructions. I subbed [Password Start Date] for DorDate and Login for CarNum. But how do I get to also pull the password associated with the most recent entry for each login?

[Brinleigh217]

Oops Nevermind, I see it now. I was in the QryMaxDates. Thanks this was a big big help!!!!

[pbaldy]

Happy to help!