>Hi Ed
>
>Two items. I cut and pasted your code into a program and ran it. I got a syntax error. The line I was baffled by as this one:
>
>MySQLComm = mSQLFldList + mSQLFldList2 + mSQLFrom + mSQLJoin + mSQLWhere + mSQLOrder
>
>I changed your code from the '&mSQLFldList.... to the one above and it ran fine.
>So first you should be concatenating your strings together. Second
>if you are passing this string to an ODBC connection you will probably get an error. I hear that SQLExec has probs with strings over 255.
>
>Thanks
>Rod
We finally located the problem...We kept running parts of the string until we found it was bombing on the BETWEEN statement...although we all knew it, we had missed that we needed question marks in front of the variables for the statment to go to SQL. we inserted the question marks and it ran.....
thanks to all for the help!



Ed