Solved

MS Access Query Filter Criteria for Joined Field

Posted on 2008-09-30
4
333 Views
Last Modified: 2013-11-29
Another easy problem (in theory) that has me stumped.  I want to filter the results of a query within my query.  The field I want to apply the filter to is a result of joining two fields from another query.  It seems I can't use my usual method of applying criteria: simply using the criteria box in query design view.  Is there a work around?  More specifically, I am pulling a couple of fields, Field1 and Field2, into one field, "Identifier", in query "qrySortID".   "Identifier" takes an alphanumberic form: "AA 11" (AA from 'Field1" and "11" from "Field2").  I have hundreds of records with several dozen different identifiers, but want to filter based on about a dozen of them ("AA 11" or "AA 38" or "BB 58" or "EE 87" and so on).  As always, thanks for the help!
0
Comment
Question by:matthewlorin7
[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
4 Comments
 
LVL 10

Expert Comment

by:calpurnia
ID: 22610152
Please can you post the SQL for your query.
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22610424
select * from qrySortID
where [identifier] in('AA 11','AA 38','BB 58','EE 87')    

just add the rest enclosed with ' ' and separate with comma
0
 

Author Comment

by:matthewlorin7
ID: 22619287
capricorn1:  Thank you, but it did not work.  Is it possible to to apply filter criteria to a field that is the result of two joined fields?  I can apply filter criteria to any other field, but not the one that is joined.  Thanks for the continued help.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22619379
post the sql of your query qrySortID322
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

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 Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

623 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