use of wildcard in parameter query

  • Thread starter Thread starter Sarah G
  • Start date Start date
S

Sarah G

I have a query that looks for all items with a particular colour. I can do
this with a normal query by typing Like *red*. I wish to make this option
available to users and set up a parameter query but when I type *red* it
returns nothing. Hoping you can help me
 
In the Criteria row of your query, instead of:
[What color]
enter:
Like "*" & [What color] & "*"
 
Worked well. Thank you
Allen Browne said:
In the Criteria row of your query, instead of:
[What color]
enter:
Like "*" & [What color] & "*"

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Sarah G said:
I have a query that looks for all items with a particular colour. I can do
this with a normal query by typing Like *red*. I wish to make this option
available to users and set up a parameter query but when I type *red* it
returns nothing. Hoping you can help me
Click to expand...
Click to expand...
 
Back
Top