parameter query with multiple entries

  • Thread starter Thread starter lynn.atkinson
  • Start date Start date
L

lynn.atkinson

Can I have a parameter query where the user just types the
various criteria in to one dialog box? eg I want to find
location 1, location 2 and location 3 from the Location
Field. Do I have to put 3 parameter queries or can I put
an expression which would mean: find 'location 1'
or 'location2' or 'location 3' when the user types into
the dialog box?

Hope this makes sense!
 
You could possibly use:
WHERE Instr([Enter Locations], [Location]) >0
This might cause issues with entering "Allenton,Pittsburgh" will also match
"Allen" and "Pitt".
 
Back
Top