Wildcards and Parameters

  • Thread starter Thread starter QueryMan
  • Start date Start date
Q

QueryMan

I have created a query that prompts users to enter the
company name to help minimize their search, however, the
users do not always know the exact spelling...etc of the
company. Is there a way for me to edit/create the
parameter so that users can search using a partial company
name rather than the exact name?

Thanks in advance.

Ed
 
I have created a query that prompts users to enter the
company name to help minimize their search, however, the
users do not always know the exact spelling...etc of the
company. Is there a way for me to edit/create the
parameter so that users can search using a partial company
name rather than the exact name?
Click to expand...

Use a criterion of

LIKE "*" & [Enter company name or part of it:] & "*"
 
Back
Top