I need to modify a query that retrieves a data from an Access db. Currently the query will allow only one parameter to be passed. It is a entered into an Excel cell that activates the query every time the cell is updated. I need to pass a table of values to Access instead of just the one value. Here is the current 'Where' portion of the query:
WHERE Cp.id = F1.id AND Cp.id = Fp.id AND Fl.lab = F1.lab AND Fl.labnid = F1.labnid AND F1.id = Fp.id AND ((F1.gsq=?) AND (Fp.pc=1) AND (Fp.cp=1))
I need to pass one to many F1.gsq values to Access to retrieve data. Any help given is greatly appreciated. Thanks.
Bookmarks