How to filter a query using a field from another table in access?
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!
How can I use the filter table tblFilter to filter out my query on EmpBasic?
Thanks in advance!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
That does the job though!
That does the job though!
<< to filter out my query on EmpBasic? >>
I was reading that backwards. Sorry about that.
Glad you worked it out.
I was reading that backwards. Sorry about that.
Glad you worked it out.
ASKER
No problem.. It got the job done!
Thanks for the prompt help!
Thanks for the prompt help!
Microsoft 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.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
SELECT EmpBasic .* FROM EmpBasic INNER JOIN tblFilter ON EmpBasic.ebEmpID = tblFilter.EMPID