What is the wild card for an Access query (MS query) parameter?

[AFSSkier]

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

 

[ryguy7272]

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

 

[AFSSkier]

I was missing the "Like" operator. The wild card % works for this: Like
[Enter Group ID].
--
Thanks, Kevin

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

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