Cannot get the SQL code to work inside VBA code

[eastgoddes]

figured out I can do a SELECT with DoCMD.RUNSQL, but need to use SELECT INTO

[alansidman]

Often, when I have coding issues relative to SQL and VBA, I create a query using the QBE and then copy the SQL statement into the VBA.

Additionally, somewhere, I found this neat little utility that converts SQL to VBA. Import this form into any Access DB and use it.