I've a Database Query with Command Text that looks like this (Command Type SQL);
SELECT
ILE."Item No_",
ILE."Posting Date",
ILE."Entry Type",
ILE."Location Code",
ILE.Quantity
FROM
"Production".dbo."Item Ledger Entry" ILE
WHERE
ILE."Item No_" In (?)
I can then set to "Get the value from the following cell" in Parameters for the above question mark in the WHERE statement. That works well if I only type a single "Item No" in my cell (for example my parameter cell is cell I2, and in that cell is FE02C). However, I'd like to have a list of acceptable values in cell I2, such as FE02C, FE02D, FE0ZZ, etc.,.
Suggestions?
Bookmarks