Query to select latest date among several

[John]

I have a query that returns this recordset:
Bob, 1/1/2000
Bob, 3/1/2001
Bob, 2/4/2004
Bob, 5/9/2002

I need the query to return this instead:
Bob, 2/4/2004

So, it needs to return the most recent date in records that otherwise
have repeating data.

Thanks for any tips!

[Adrian Tofan]

Group By Name and select Max of Date
"John" <so*********@ho tmail.com> wrote in message
news:90******** *************** ***@posting.goo gle.com...

I have a query that returns this recordset:
Bob, 1/1/2000
Bob, 3/1/2001
Bob, 2/4/2004
Bob, 5/9/2002

I need the query to return this instead:
Bob, 2/4/2004

So, it needs to return the most recent date in records that otherwise
have repeating data.

Thanks for any tips!

[John]

Thanks Adrian; however, I thought I'd be able to figure out a more
complex problem by making it simpler. What if there's a third field
that makes the record unique. Example
Bob, 1/1/2000, $19.98
Bob, 3/1/2001, $24.98
Bob, 2/4/2004, $29.98
Bob, 5/9/2002, $26.98

The query still needs to return the most recently dated record:
Bob, 5/9/2002, $26.98

Using MAX on the date field still returns multiple records due to the
price field making them unique. Any suggestions?

"Adrian Tofan" <x@x.x> wrote in message news:<tH******* **************@ twister01.bloor .is.net.cable.r ogers.com>...

Group By Name and select Max of Date
"John" <so*********@ho tmail.com> wrote in message
news:90******** *************** ***@posting.goo gle.com...

I have a query that returns this recordset:
Bob, 1/1/2000
Bob, 3/1/2001
Bob, 2/4/2004
Bob, 5/9/2002

I need the query to return this instead:
Bob, 2/4/2004

So, it needs to return the most recent date in records that otherwise
have repeating data.

Thanks for any tips!