<div>
Or even this, using an inner join (might be faster)<br />
<br />
SELECT EmpBasic .* FROM EmpBasic INNER JOIN tblFilter ON EmpBasic.ebEmpID &nbsp;= tblFilter.EMPID
</div>


<div>
The tblFilter actually contains a list of the EmpIDs I don't want to appear in the query.. I just changed the first example to NOT IN.<br />
<br />
That does the job though!
</div>


<div>
&lt;&lt; to filter <b>out </b>my query on EmpBasic? &gt;&gt;<br />
<br />
I was reading that backwards. &nbsp;Sorry about that.<br />
<br />
Glad you worked it out.
</div>


<div>
No problem.. It got the job done!<br />
<br />
Thanks for the prompt help!
</div>


<div>
<div class="content wysiwyg-content">
I have a table called EmpBasic which lists Employees. I want to run a query on that table that gets any ebEmpID filtered out based on the EmpIDs found in tblFilter.<br />
<br />
How can I use the filter table tblFilter to filter out my query on EmpBasic?<br />
<br />
Thanks in advance!
</div>
</div>


I have a table called EmpBasic which lists Employees. I want to run a query on that table that gets any ebEmpID filtered out based on the EmpIDs found in tblFilter.

How can I use the filter table tblFilter to filter out my query on EmpBasic?

Thanks in advance!

Or even this, using an inner join (might be faster)

SELECT EmpBasic .* FROM EmpBasic INNER JOIN tblFilter ON EmpBasic.ebEmpID  = tblFilter.EMPID

The tblFilter actually contains a list of the EmpIDs I don&#39;t want to appear in the query.. I just changed the first example to NOT IN.

That does the job though!

&lt;&lt; to filter out my query on EmpBasic? &gt;&gt;

I was reading that backwards.  Sorry about that.

Glad you worked it out.

No problem.. It got the job done!

Thanks for the prompt help!

How to filter a query using a field from another table in access?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.