Hello everyone, I have been working on getting an excel sheet together where I can query multiple parameters. I have tried using the Connection Properties window and editing my query. But there are to many parameters that I need at any given time. This is what I have tried thus far I have tired getting the data from another table using =(table!T10:T600)This works)). This table changes on a daily basis so a cell that may be blank today would be populated tomorrow and vise versa. I have a connection to SQL and I have tired using the edit query button from the connection properties window to create a query using IN OR (example: SELECT * FORM DATABASE.DBO.TABLE WHERE (TABLE.COLUMN IN (?)) OR (TABLE.COLUMN IN (?)) etc...
I did this for about 40 parameters that reference a cell where data would or would not be. I have also tried using textjoin to comma delimit the data and refence that data using a query. Currently I can only add on value to the cell to get data to return using the textjoin method.

Does anyone have any suggestions how what I am trying to do could be accomplished?


Thanks AC