|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 8th, 2004, 05:12 PM
|
|||
|
|||
parameter query with multiple entries
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! 
|
|
#2
July 8th, 2004, 06:53 PM
|
|||
|
|||
|
parameter query with multiple entries
You could possibly use:
WHERE Instr([Enter Locations], [Location]) 0 This might cause issues with entering "Allenton,Pittsburgh" will also match "Allen" and "Pitt". -- Duane Hookom MS Access MVP "lynn.atkinson" wrote in message ... 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!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert to a Parameter Query | Al Eaton | General Discussion | 3 | July 9th, 2004 04:05 PM |
| export 1 query multiple times to 1 excel file | WALRUSIM | Running & Setting Up Queries | 1 | June 19th, 2004 04:13 AM |
| Parameter Query Help | mark | Running & Setting Up Queries | 4 | June 2nd, 2004 04:40 PM |
| Using a query with a replaceable parameter as the source of a control | Hoo | Using Forms | 2 | May 30th, 2004 09:43 AM |
| Using a query with a replaceable parameter as the source of a control | Hoo | Running & Setting Up Queries | 1 | May 30th, 2004 07:07 AM |
Linear Mode
