vba sql query

[si_the_geek]

Have you tried the suggestion I made in your other thread?

OK, well try the really simplified version:

  str = "SELECT CCSMS.CUST_NO " _
    & "FROM CSPCL, CCSMS " _
    & "WHERE CCSMS.CUST_NO = CSPCL.CUST_NO "