passing a parameter to LIKE "*.....*"

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

How do I constract a parameterised query where the parameter to be entered goes to

LIKE "*parameter*" ?
 
Set the criteria to
Like "*" & [Enter Parameter] & "*"

--
Duane Hookom
MS Access MVP


How do I constract a parameterised query where the parameter to be entered goes to

LIKE "*parameter*" ?
 

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

Similar Threads

Parameter Query Won't Run 0
Like "* " and function to pass parameters into a query 4
Pass Parameter to stored procedure in pass thru query 7
Modify Parameter Query 1
Access Invalid bracketing of parameter name 1
Parameter Query help - Not passing parameter? 3
Passing a List through a Parameter 7
query too complex to pass optional parameters 1

Back
Top