I知 setting up a spreadsheet to pull data from a SQL DB. I have all my links done, but I am having a little trouble with my criteria in my Microsoft query. I want the report to prompt for new data every time the data is refreshed. So in my Value field I am using the brackets [Enter Job Number] However, where I am having trouble is that I want it to be a starts with not an equals. I知 getting syntax when I try Like [Enter Job Number]% Is there a way to do what I am trying to do?
Bookmarks