Help me! What Wrong With DoCmd.RunQuery? (1 Viewer)

[zainuddin001]

What is wrong wioth my SQL syntax?
I got this message when I run the below SQL.
Help me please!

Run-time error
Syntax error (missing operator) in query expression 'NameFROM
Members'.

Sub RunMySQL()
Dim SQLName As String
SQLNama = "INSERT INTO TempName ( NameID, Name )" _
& "SELECT Members.NameID, Name" _
& "FROM Members WHERE NameID Like *2002*"
DoCmd.RunSQL SQLName
End Sub

 

[RichMorrison]

Put a space between "name" and "FROM"

RichM