Combobox datasource SQL question

[hascons]

Hello

I have a time sheet form on which i have a combo box that has its recordsource filtered by an SQL statement to return only employees whose "Last Worked Date" field is blank. When I enter the time for each employee into a time card table, I would like to have this employee removed from the combobox to make finding employees easier with longer lists.

Can this be done with some kind of ( Not Select Statement )? When i create a query using the employee table and filter with " IsNull " Statement in "Last Worked Date" Field it returns the Current employee list fine. If I add the "Time Card Table" and relate the EmployeeID fields in each table, the results are to return Only the Employee entered in the "Time Card Table" which is understandable. I would actually like to return all the other Current employees in the list with the exception of the employees entered in the "Time Card Table".

Any Ideas?



Steve

[June7]

Is the join type an INNER? Try LEFT or RIGHT ("Include all records from Employees and only those from Time Card Table that match").

[hascons]

Is the join type an INNER? Try LEFT or RIGHT ("Include all records from Employees and only those from Time Card Table that match").

Thanks for your quick reply

Here is the SQl Statement

SELECT [Employees Extended].EmployeeID, [Employees Extended].[Employee Name], [Employees Extended].DateTerminated, [Temp Time Card Entry].Dateworked
FROM [Employees Extended] Inner JOIN [Temp Time Card Entry] ON [Employees Extended].EmployeeID = [Temp Time Card Entry].EmployeeID
WHERE ((([Employees Extended].DateTerminated) Is Null) AND (([Temp Time Card Entry].Dateworked)>#4/16/2014#))
ORDER BY [Employees Extended].[Employee Name];

What i'm trying to do is as follows

Employee Table Time Card Table
(after filtering for just current employees) ( employee time entered )
---------------------------------------------------------------------

John Smith John Smith
Steve Jobs
Bill Gates

In the combobox on time sheet i would like to have ( John Smith) removed from
the list since his time would have already been entered.

[hascons]

I solved this issue by using a left join and retrieving records from Time card Table where the Id was null
I used the following SQL Statement:

[Code]
SELECT [Employees Extended].EmployeeID, [Employees Extended].[Employee Name], [Employees Extended].DateTerminated, [Time Card Entry].TimeCardID
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];

[Code]