Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters query help

Status
Not open for further replies.

docmeizie

Programmer
Aug 5, 2003
326
US
What I want to do is have a parameters query that runs like this:

Code:
*[Parameter Prompt]*

I want to use the wild card characters but it seems to not be working to well it installs that Like statement and the parentheses which nullifies my Prompt. Is there anyway around this and if so how? Thanks for helping in advance.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
 
Never mind, silly me. I forgot you have to do it like this:

Code:
Like "*" & [Parameter Prompt] & "*"

Bad case of the Monday's I guess.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv [pc1][shocked]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top