View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DT DT is offline
external usenet poster
 
Posts: 20
Default Wildcard Character Placement in MS Query

I am attempting to establish a parameter in Excel containing a wildcard
before the prompt. I have successfully written it in access as: Like
"*"&[Enter City]) but cannot successfully accomplish it in MS Query. I am
currently entering the wildcard as part of the prompt response but this
limits me in other areas. Thank you for your help.