| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter Query to return multiple values
I have a query with a parameter which prompts the user to enter a product
code. The query works fine if the user puts a product code in, but how should the user enter more than one product code to return a query containing more than one product code. I have tried AND and OR and have had no luck. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameter Query to return multiple values
I believe you'll need to post this in the Access forum.
-- Kevin Backmann "Ruth" wrote: I have a query with a parameter which prompts the user to enter a product code. The query works fine if the user puts a product code in, but how should the user enter more than one product code to return a query containing more than one product code. I have tried AND and OR and have had no luck. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Parameter Query to return multiple values
Sorry, I should have been more specific with my question. I am working in
Microsoft Excel and importing data via Microsoft Query. "Kevin B" wrote: I believe you'll need to post this in the Access forum. -- Kevin Backmann "Ruth" wrote: I have a query with a parameter which prompts the user to enter a product code. The query works fine if the user puts a product code in, but how should the user enter more than one product code to return a query containing more than one product code. I have tried AND and OR and have had no luck. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| parameter query - multiple options | Excel Discussion (Misc queries) | |||
| Parameter Query? | Excel Discussion (Misc queries) | |||
| Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
