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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query for Multiple Columns with drop box of choices 3
Parameter Query Won't Run 0
Multiple Parameter Crosstab query filter by form 1
Problem with a parameter query 7
Parameter Query 2
Calculations in an Inventory data Base 5
Parameter Queries in Crosstab Query 2
Combining Multiple Records 1

Back
Top