Left Join Problems

[hascons]

Hello,

I thought I had solved this Problem from another post but I overlooked something and now it's causing some grief.

I'm trying to return left table values where there are no matching records in the right table. The following code works to accomplish this if the data is not updated.

SELECT [Employees Extended].EmployeeID, [Employees Extended].[Employee Name], [Employees Extended].RateClassID, [Employees Extended].TradeID, [Employees Extended].State, [Time Card Entry].Dateworked
FROM [Employees Extended] LEFT JOIN [Time Card Entry] ON [Employees Extended].EmployeeID = [Time Card Entry].EmployeeID
WHERE ((([Employees Extended].DateTerminated) Is Null) AND (([Time Card Entry].TimeCardID) Is Null) 
ORDER BY [Employees Extended].[Employee Name];

However because the data from the right table continuously updates weekly from the table on the left I always get blank data back from running the query. I tried to add a filter to only return the current data from the right table but i still end up with blank data. Below is the same code above with the addition of another filter to use current data.

Why won't this work?
Are there too many filters for a left join?

SELECT [Employees Extended].EmployeeID, [Employees Extended].[Employee Name], [Employees Extended].RateClassID, [Employees Extended].TradeID, [Employees Extended].State, [Time Card Entry].Dateworked
FROM [Employees Extended] LEFT JOIN [Time Card Entry] ON [Employees Extended].EmployeeID = [Time Card Entry].EmployeeID
WHERE ((([Employees Extended].DateTerminated) Is Null) AND (([Time Card Entry].TimeCardID) Is Null) AND (([Time Card Entry].Dateworked)>#4/6/2014#))
ORDER BY [Employees Extended].[Employee Name];

Any help would be greatly appreciated, I just can't seam to find any information on this type of join with multiple where statements

[ItsMe]

If you are curious why some null fields are still being retrieved, try the OR operator vs. the AND operator.