>The following SQL connection works
>
>SQLEXEC(gnConnHandle, 'SELECT COMPANY, POLICY FROM POLICY', 'accessquotes')
>
>However the join does not?
>
>SQLEXEC(gnConnHandle, 'SELECT P.COMPANY, P.POLICY, C.NAME FROM POLICY P, COMPANY C WHERE P.COMPANY=C.COMPANY', 'accessquotes')
>
>I am sure my table and column names are correct.
What ODBC error did you get? You can use AERROR() function to get it. I'm not familiar with ACCESS query syntax but you can try JOIN.
SQLEXEC(gnConnHandle, 'SELECT P.COMPANY, P.POLICY, C.NAME ' + ;
'FROM POLICY P JOIN COMPANY C ON P.COMPANY=C.COMPANY', 'accessquotes')
--sb--