| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the wild card for an Access query (MS query) parameter?
What is the wild card for an Excel data parameter?
I have a cell referenced criteria parameter for imported data from an Access Query. If a single criteria is posted I get that group. How can I get the data for all groups? In Access I can use the * wild card. But * doesn't pass to the query from excel. I've also tried %. -- Thanks, Kevin |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the wild card for an Access query (MS query) parameter?
The wildcard character in ADO is %, not *. Maybe you set it up wrong. Here
is an example that I use: Like "*" & [Forms]![MyForm]![ComboBox1] & "*" Are you using the Like operator? Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "AFSSkier" wrote: What is the wild card for an Excel data parameter? I have a cell referenced criteria parameter for imported data from an Access Query. If a single criteria is posted I get that group. How can I get the data for all groups? In Access I can use the * wild card. But * doesn't pass to the query from excel. I've also tried %. -- Thanks, Kevin |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What is the wild card for an Access query (MS query) parameter
I was missing the "Like" operator. The wild card % works for this: Like
[Enter Group ID]. -- Thanks, Kevin "ryguy7272" wrote: The wildcard character in ADO is %, not *. Maybe you set it up wrong. Here is an example that I use: Like "*" & [Forms]![MyForm]![ComboBox1] & "*" Are you using the Like operator? Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "AFSSkier" wrote: What is the wild card for an Excel data parameter? I have a cell referenced criteria parameter for imported data from an Access Query. If a single criteria is posted I get that group. How can I get the data for all groups? In Access I can use the * wild card. But * doesn't pass to the query from excel. I've also tried %. -- Thanks, Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pass parameter to access query | Links and Linking in Excel | |||
| Call parameter query in Access from Excel VBA? | Excel Programming | |||
| Cell value as parameter for VBA access query | Excel Programming | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Pass Parameter to Access Query | Excel Programming | |||
Hybrid Mode
