Hi!

I'm using SQL to retrieve information from another worksheet within the same workbook.

The SQL statement works fine when I use 1 or 2 arguments after SELECT. However, if I want a 3rd argument, I get a type mismatch error.

The same goes for WHERE statement. If I use more than 2 conditions, I get the same error.

Any ideas why?

And what is the best option (other than ODBC) for using SQL within the same workbook?

Thanks in advance!