OK, thanks!
That brings up another question though; is it possible to programmatically
set the parameter ranges for a query?

/Marcus

"Gary Brown" wrote:


When you use parameter queries in MS Query, it treats the value in the
parameter as a single text string, therefore if you have a condition of
In([Parameter1]), if you enter a value of A,B,C or 'A','B','C' it tries
to retrieve records which equal A,B,C or 'A','B','C' and not as you
want.

The only thing I can suggest is setup multiple parameters and use OR
to relate them to each other, and then use a combo box, to select the
options, have a formula which extracts each option into individual
cells. When these cell values change, get the query to run by selecting
option 3 on the parameter icon within excel.

This probably wasn't what you wanted to hear, but having used MSQuery
and parameters a lot, this is the only solution I have found to date.


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=535886