I know, I hate all those paraenthesis. When I'm doing testing though I usually just create my queries in Microsoft Access and then paste the SQL into my VB code and then rewrit it to more acceptable once know it is wrking properly. Saves a bit of time is all when your trying to stumble through something.