Hi Roger, thanks for the reply.

The IN thing isn't the problem it works fine in a smaller query.

In the code i posted, i do a smaller sql query, slq2, which works fine


Also the MsgBox(sQL) prints out only 3/4 of the whole string whic
means there is some limit to the maximum allowable characters. I wan
to know if there is a way around this, like defining a block string an
making it a bigger size.

I tried the MSDN library but no luck

--
Message posted from http://www.ExcelForum.com