Query Help Needed

[djcirello]

Hello,

Extreme newly to the forum and of course I could use a little guidance setting up a query in Access 2013. I have a table similar to the one typed below. I would like a query to return person's the name and only the highest value associated with that person.

John	2
John	18
Sally	10
Sally	14
Ted	6

So looking at the data listed above here is what I would like returned.

John 18
Sally 14


Ted 6

Please advise on how I can do this?

Kind Regards,
Darin

[pbaldy]

You just need the first query here:

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

[djcirello]

I will try this today.

You just need the first query here:

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

[pbaldy]

No problem; post back if you get stuck.