Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

MS Access Query Filter Criteria for Joined Field

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
matthewlorin7
Asked:
matthewlorin7
  • 2
1 Solution
 
calpurniaCommented:
Please can you post the SQL for your query.
0
 
Rey Obrero (Capricorn1)Commented:
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
 
matthewlorin7Author Commented:
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
 
Rey Obrero (Capricorn1)Commented:
post the sql of your query qrySortID322
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now