need help in writing query

[cancer2006]

I am working in access97 need help in writing a query
Table1 has two columns with ID and NAME.
Table2 has has two columns, ID and CHECKDATE.

In Table2, there are multiple checkdates associated per ID

I like to run a query which will give me the highest checkdate on each employee in Table2

Select table2.checkdate, table1.name
inner join on table1
where table2.id = table1.id;

This qurey will result in all the checkdates in table2.

Any ideas. Thank you

 

[PHV]

SELECT table1.name, Max(table2.checkdate) AS LastDate
FROM table1 INNER JOIN table2 ON table1.id = table2.id
GROUP BY table1.name

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886