Querry For The Most Recent Date

I'm replying because I am having the same sort of problem with my current database. I do have the separate tables like don has described. Basically here is what I have:

Employee table:
Employee number (primary key)
Other fields for employee information

Training table: (A different table for each training that I am tracking)
ID (autonumber - primary key)
Employee number
Training Date

There is a new entry on the training table each time an employee completes a training. I then have a query that links the 2 tables (using a join between employee number) and calculates next training due dates and filters to overdue training and trainings that are due in the next 30 days. Currently, the query is not pulling in the most recent training dates for each employee. What do I need to do to the query design so that it will only pull in the most recent training date for each employee? Any help would be greatly appreciated.

Thanks.