[RESOLVED]-INSERT SQL question...

[BenFinkel]

Maybe I'm a retard, but does anyone see anything wrong with this line of code?

strSQL = "INSERT INTO tblCompetitors " & _
   "( strName, strStreet, strCity, strState, strZip, strManager, strP_ID ) " & _
   "SELECT '" & strName & "' AS Name, " & _
   "'" & strStreet & "' AS Street, " & _
   "'" & strCity & "' AS City, " & _
   "'" & strState & "' AS State, " & _
   "'" & strZip & "' AS Zip, " & _
   "'" & strManager & "' AS Manager, " & _
   "'" & Session("StoreNumber") & "' AS P_ID;"

Because when it runs, it inserts ALL six fields worth of data into strName in tblCompetitors.

Thanks!

--Ben