I created a query that would determine who our current employees are.
The result of TermDate - Criteria: Is Null
Jesse clearly has a TermDate. Other employees listed in the tblEmployees with a TermDate value do not populate when the query is run. In an effort to remove Jesse from the list, I tried adding a second layer to catch him -- thus the Voluntary and Involuntary fields in the query. In the query I set the Criteria for Voluntary to No. I did the same for Involuntary. Jesse is still hanging around. Please help me get rid of Jesse.