Solved

Query table and only return results NOT in another table in ACCESS

Posted on 2014-11-25
2
163 Views
Last Modified: 2014-11-25
I have 2 tables Humres with a field em_id and another table (dbo_emptrain) that has a field empID.  The Humres table has ALL employees listed in it, the emptrain table has only employees that we have assigned something in this database.  I want to run a query that shows me only employees that haven't been assigned to the emptrain table.
0
Comment
Question by:sharris_glascol
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 40464495
If you don't know how to create a left join, then use the "unmatched" wizard to create the query for you.

Select ...
From tblA Left Join tblB On tblA.em_id = tblB.empID
Where tblB.empID Is Null;
0
 

Author Closing Comment

by:sharris_glascol
ID: 40464511
Thanks I have done numerous queries and feel dumb this was so simple.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now