simple access query 1

[mldmld]

I have one table with just names (Table1).
The other table has the same names with multiple dates for each name(Table2).
What is the code to locate the most current date for each name?

Thanks for the time, I have lost my access book and rarely use access.

 

[markgrizzle]

SELECT tbl2.Name, Max(tbl2.DateField) AS LastDate
FROM tbl2 GROUP BY tbl2.Name;