Delfinus25
Board Regular
- Joined
- Feb 27, 2016
- Messages
- 80
I am connected to an AS400 database using Microsoft Query iSeries ODBC.
I want to use a parameter and allow the user to put in a list.
i.e. where x.Store NOT IN (003,006,008)
I tried entering a parameter (?) here, and referencing a cell, but I keep getting a length error.
How do I allow the user to input this list when I don't know how long / how many stores it will contain?
I want to use a parameter and allow the user to put in a list.
i.e. where x.Store NOT IN (003,006,008)
I tried entering a parameter (?) here, and referencing a cell, but I keep getting a length error.
How do I allow the user to input this list when I don't know how long / how many stores it will contain?
