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