Excluding records from one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
 
Michelle,

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

HTH,
Josh
 
Michele,

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

HTH,
Josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query excluding listings from table 2
Have both records from two queries/tables under one Query without related fields. 0
Two Table Query 4
Exclude Records via Join? 4
Exclude like values with a JOIN? 5
Exclude Records based on a joined field? 8
Excluding 2
Need to filter portfolios listed in 1 query from appearing in new 1

Back
Top