SQL syntax error (VBA issue)

[pook_666]

Hi team - I am getting a "incorrect syntax near 'cust_id' error from the below code in VBA.

I've tried the below in SQL Server and it works, so must be an issue in VBA?

Not sure if this is more an SQL query rather than VBA issue, but any help would be great! Thanks!!

SQLQry = "SELECT cust_name, cust_contact" & _
    "FROM customers" & _
    "WHERE cust_id IN (SELECT cust_id" & _
                      "FROM orders" & _
                      "WHERE order_num IN (SELECT order_num" & _
                                          "FROM orderitems" & _
                                          "WHERE prod_id = 'RGAN01'))"

 

[jimrward]

Try the following by either putting a space before each closing double quote on every line or one after every opening one
try a debut.print or message sqlqry and you will see it all joined up with no space between each key word
so you might see cust_contactFROM instead of cust_contact FROM once you apply the space

 

[pook_666]

Just as simple as that....how annoying!! Thanks a lot Jim. Always forget about the debut.print.....need to have that hard-coded into my brain!

 

[jimrward]

Grrr auto correct should have said debug.print
Loads of people forget about the space including me