Solved

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

Posted on 2014-11-25
2
176 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

738 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