is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have. Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the where statement criteria?
In the query
Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE", INMSP300.M3PRD as "PN", INMSP300.M3CLS as "PrdLine", INMSP100.MSAPP, INMSP100.MSPRD, INMSP100.MSRDTM as "rtd-Month", INMSP100.MSRDTD as "rdc-Day", INMSP100.MSRDTY as "rtc-Year", INMSP100.MSMPC as "Phase" From rdb.CARF1.INMSP300 INMSP300 join rdb.CARF1.INMSP100 INMSP100 on M3PRD = MSPRD Where INMSP300.M3CLS ='77' and INMSP100.MSRDTY = '09' and INMSP100.MSRDTM = '11' order by INMSP100.MSMPC
I would like to keep these (INMSP300.M3CLS ='77' INMSP100.MSRDTY = '09 'INMSP100.MSRDTM = '11' ) open so that a pop-up would allow me to input different values. Something to the fact (INMSP300.M3CLS ='--' INMSP100.MSRDTY = '-- 'INMSP100.MSRDTM = '--' ) What would be the statement and if this is possible how would it be written.
MS2000, Access 2000
November 18, 2009 4:40 PM
February 27, 2010 6:48 AM