Most recent Date query

[SmartestIdiot]

I have a table that I imported and it has duplicate fields that I'm trying to sort out. Duplicate Names, Different Job Title, Different Dates. Trying to filter out old job titles and leave the record with the most recent Date. Tried the Group by Name, Max in Date field, but don't know what to do with the Job Title field. First, Last, Min, and Max don't work. I can't seem to get all the records to show the most recent job title. Help

[JoeM]

You can do this in a two-query process.
You already figured out the first query, group on name and take the most recent date.
Now, link this query back to your original table on the name and date fields, and you can return the rest of the information you desire.