INSERT INTO please help

[ThaiByThai]

Hello -

I'm tying to INSERT information from HRM table into HRM_final table and i am getting an error asking me to enter a Parameter value. I'm still very new at this access stuff - any help/suggestion?


DoCmd.RunSQL "INSERT INTO HRM_final SELECT HRM.SSBN, HRM.title, HRM[ORG code] FROM HRM';"


thank you!

 

[jdraw]

See the following link for the correct syntax for INSERT INTO

http://www.w3schools.com/SQL/sql_insert.asp

 

[DCrake]

Try

DoCmd.RunSQL "INSERT INTO HRM_final SELECT [SSBN], [title], [ORG code] FROM HRM;"

The syntax was wrong