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

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

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