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

A

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

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

AFSSkier

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


ryguy7272 said:
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 said:
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 %.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top