Need your suggestions

[dylan_dog]

Open your query in design view. You'll see under "table" that your query uses tables Contract Employees and Contract Employees_1. I think you copied your original table to create this one. As for multiple entries: I believe Access will give you one entry for every instance where ANY of the expiry dates falls into your range of dates. Attached is the corrected copy of your database.

 

[dylan_dog]

Jmriddic,

I'm toying with your table. One question about licensure/certification: is there a set of licenses that could aply to all eight licensures?

Regards, Samo