I am faced with a very similar challenge.

I have set up a parameter query and I have cells that store minimum
vendor number, maximum vendor number, minimum department number and
maximum department number.

The query works great for those particular variables.

I have not been able to figure out how to format cells for the buyer
number field where the selction criter is In('02,'05'). I keep getting
the message

"a buffer passed to a system call is too small to hold return data".

Any suggestions would be appreciated.

Sincerely

Jim Palmer


--
Jim Palmer
------------------------------------------------------------------------
Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210
View this thread: http://www.excelforum.com/showthread...hreadid=544546