Microsoft Query in Excel
 

I am having difficulty in creating a Parameter that will allow the user
to enter more than one entry (for example: to be able to run one query
that will return data from multiple months that you choose, like 1, 3,
and 7)

The 'In' in the criteria will work if the data is hard-coded, but I
want to be able to have _one_ prompt that will allow multiple months be
entered at the same time.

Has anyone had this problem and how did you fix it? :confused:


--
drobbins
------------------------------------------------------------------------
drobbins's Profile: http://www.excelforum.com/member.php...o&userid=28347
View this thread: http://www.excelforum.com/showthread...hreadid=479297