MS Access Query Filter Criteria for Joined Field
Posted on 2008-09-30
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!