ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wildcard Character Placement in MS Query (https://www.excelbanter.com/excel-discussion-misc-queries/166094-wildcard-character-placement-ms-query.html)

DT

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.


All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com