Excluding data from a query

[Guest]

Hi...

I have created a database with 3 tables, and I can compare data in 2 of the
tables to find any data mismatches and then report them. However, in my 3rd
table, I have a list of employee numbers that I wish to be ignored.

How do i get my query for comparing the first 2 tables, to ignore any
employees that appear in my 3rd.

Thanks :O)

 

[Joseph Meehan]

Hi...

I have created a database with 3 tables, and I can compare data in 2
of the tables to find any data mismatches and then report them.
However, in my 3rd table, I have a list of employee numbers that I
wish to be ignored.

How do i get my query for comparing the first 2 tables, to ignore any
employees that appear in my 3rd.

Thanks :O)

What is the relationship of the first two tables and the employee number
table?

 

[John Vinson]

Hi...

I have created a database with 3 tables, and I can compare data in 2 of the
tables to find any data mismatches and then report them. However, in my 3rd
table, I have a list of employee numbers that I wish to be ignored.

How do i get my query for comparing the first 2 tables, to ignore any
employees that appear in my 3rd.

Thanks :O)

One way - if you don't have a huge number of employees to ignore - is
to use a criterion of

NOT IN (x, y, z)

as a criterion on the EmployeeID field (using the ID's of those
employees).

I've worked in companies where there were some employees I'd have
liked to be able to ignore - so I sympathise! <g>

John W. Vinson[MVP]