Seemed easy at first...

[ianforest]

Hi guys. I have a bit of a problem. I'm a complete green behind the ears novice as well (which doesn't help!)

I have a database with 2 tables. One for employees and holds their data (name, address, etc.) and one for jobs (jobno, date, employee, etc.)

The 2 tables are linked using a one-2-many (one employee, many jobs) relationship.

I want to develop a query which will enable me to query the jobs table with a date string. The result I am after is a list of employees who are NOT working on that particular date.

I think in retrospect, it is the EMPLOYEES table I need to query not the JOBS table.

I can get it to list jobs that do not match the date entered, that's pretty simple, but if I add both tables to the query design) and include 'employeename' from the EMPLOYEES table and 'jobdate' from the JOBS table it just gives me a list of jobs that do not match the date I entered.

Any guides or pointers?

Thanks in advance.

Ian.

 

[Fuga]

Select jobs from jobs table (select query) with the date as criteria, and then make a missmatch query on the employee fields.

Fuga.

 

[ianforest]

Cheers i'll give that a go and let you know how I get on.

Ian.

 

[ianforest]

Wonderful...worked perfectly!