 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / April 2006Excluding records from one table
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 > 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 [quoted text clipped - 3 lines] > > Thx 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, > [quoted text clipped - 16 lines] > > > > Thx Michelle, Thanks for clarifying, but that was my understanding of your problem. My suggestion should work or try the unmatched 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 [quoted text clipped - 23 lines] > > > > > > Thx Michele, Excuse me, the criteria should find for nulls in the 06Hires tables. Use 'Is Null' for your criteria. HTH, Josh > Michelle, > [quoted text clipped - 38 lines] > > > > > > > > Thx |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.