Need Help with nasty query

[Bill]

I have a table that stores user id and what date they where checked in
last.

Driver_ID Date
12 1/31/2006
12 1/16/2006
12 1/12/2006
24 1/31/2006
24 1/16/2006
24 1/12/2006

I'm trying to make a query that will give me a unique Driver_ID and
show the most recent date that from the table.

Driver_ID Date
12 1/31/2006
24 1/31/2006

I know that I'm going to need to have a sub-query to make this work. Up
to this point though I've onle been able to get it to show just one
record. Any ideas how to make this work.

[me321701]

Try

select driver_id, max([date])
from tablename
group by driver_id

You really shouldn't use date as the column name

Mark
On 31 Jan 2006 17:16:08 -0800, "Bill" <wl*********@gmail.com> wrote:

I have a table that stores user id and what date they where checked in
last.

Driver_ID Date
12 1/31/2006
12 1/16/2006
12 1/12/2006
24 1/31/2006
24 1/16/2006
24 1/12/2006

I'm trying to make a query that will give me a unique Driver_ID and
show the most recent date that from the table.

Driver_ID Date
12 1/31/2006
24 1/31/2006

I know that I'm going to need to have a sub-query to make this work. Up
to this point though I've onle been able to get it to show just one
record. Any ideas how to make this work.

[Bill]

Thanks. That looks to have taken care of the problem.