Excluding records from one table

M

Michele

I've pulled two tables (EIS and 06Hires) together in one query. I want to
exclude all information for all ppl in 06Hires table. I've right joined EIS
on 06Hires.EmplId=EIS.EmplID. How do I go about setting this up in the
criteria? Ultimately this query will produce a table that is used in another
query.

Thx
 
J

Joshua A. Booker

Michelle,

If I understand what you're looking for, you should be able to restrict
nulls on the field 06Hires.EmpId by placing Is Not Null in the criteria.
Make sure the arrow of the join points to the 06Hires table.

If that doesn't work, then try the 'Find Un-Matched Query Wizard'

HTH,
Josh
 
M

Michele

Actually the tables are called EIS and 06 Hires. The EIS tble will contain
the ppl that are in the 06Hires table. The fields names are identical in
each tble. Basically I want to create a make-table query that ensures that
all ppl that are in the 06Hires tbl are not going to be included in the new
tbl. In a rough translation, New tbl will contain the same employees found
in EIS less those employees found in 06Hires. Any suggestions?
 
J

Joshua A. Booker

Michelle,

Thanks for clarifying, but that was my understanding of your problem. My
suggestion should work or try the unmatched wizard.

HTH,
Josh
 
J

Joshua A. Booker

Michele,

Excuse me, the criteria should find for nulls in the 06Hires tables. Use
'Is Null' for your criteria.

HTH,
Josh
 
Top