Query with Is Null returning results with values

[Ron_PTC]

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.

[orange]

It would be easier if you posted the SQL of the query.
Go to sql view and copy the code.

[Ron_PTC]

Here you go:

SELECT tblEmployees.TermDate, tblEmployees.FirstName, tblEmployees.Voluntary, tblEmployees.Involuntary
FROM tblEmployees
WHERE (((tblEmployees.TermDate) Is Null) AND ((tblEmployees.Company) Like "PTC/DEC*") AND ((tblEmployees.Voluntary)=No) AND ((tblEmployees.Involuntary)=No)) OR (((tblEmployees.Company) Like "CH/DEC*"));

[Ron_PTC]

Got it once I saw it written out. Looks like the criteria applied to the first company sort (like "PTC/DEC*) and not the second sort (like "CH/DEC*)

Thanks

[orange]

Glad you have it working.

Here is a different view of the SQL

SELECT tblEmployees.TermDate
	,tblEmployees.FirstName
	,tblEmployees.Voluntary
	,tblEmployees.Involuntary
FROM tblEmployees
WHERE (
		((tblEmployees.TermDate) IS NULL)
		AND ((tblEmployees.Company) LIKE "PTC/DEC*")
		AND ((tblEmployees.Voluntary) = No)
		AND ((tblEmployees.Involuntary) = No)
		)
	OR (((tblEmployees.Company) LIKE "CH/DEC*"));

This layout helps see things.