MS Access query to return the most recent record from a table?

Hello Experts.

Well, apparently I lack the ability to learn from the hundreds of posts that cover this same question so I am reaching out for some guidance.

I have two tables:  tbl_emp and tbl_emp_assnmt.  tbl_emp contains all of our employees and tbl_emp_assnmt holds all their assignments.  Each employee can have multiple assignments.  I would like to pull just the most recent tbl_emp_assnmt for each employee.  Here's the query that pulls everything:

SELECT 
tbl_emp.emp_id_pk, 
tbl_emp_assnmt.entry_dt, 
tbl_emp_assnmt.unit_ddl, 
tbl_emp_assnmt.dept_ddl
FROM tbl_emp

LEFT JOIN tbl_emp_assnmt

ON  tbl_emp.emp_id_pk = tbl_emp_assnmt.emp_id_fk

Select allOpen in new window

I would like the most recent assignment based on the Assignment Entry Date (tbl_emp_assnmt.entry_dt) field.  Once catch though, not everybody has assignments yet, and I need them to be in the results of this query also.  So this query should return the most recent assignment for each employee, and just the employee (tbl_emp.emp_id_pk) if there aren't any assignments yet.

I hope this makes sense.  Any help would be greatly appreciated.  

I'm using MS Access 2010.

Thanks,
J