Start and end dates, how to pull most current info in a query

[Yogibear]

I have a database that has two tables: tblBio and tblEmployment (a one-to-many relationship).



tblEmployment has two fields that are "start date" and "end date." Any record that does not have an end date contains the most current information.

How do I run a query that would only pull the most current information from the tblEmployment?

Thank you to anyone who can help......

[pbaldy]

Try a criteria of

Is Null

On the end date field.