syntax correction needed

[Desert Bear]

The syntax for the following is not quite correct.
Dim lngPeoID as integer
Dim sSQL as String

Access complains about syntax for both of the following versions of an SQL stmt (with and without {[])
sSQL = "Insert into tblVersion ([peoPeopleID] Values (" & lngPeoID & ")"
sSQL = "Insert into tblVersion (peoPeopleID Values (" & lngPeoID & ")"

 

[Dan Artuso]

Hi,
You're not closing the first (
sSQL = "Insert into tblVersion (peoPeopleID) Values (" & lngPeoID & ")"

 

[Desert Bear]

Thanks. I had taken the paren as belonging to the whole statement.
It still doesn't come out even. I need to remember my days of counting parens in programs.