COUNT field incorrect or syntax error

[Bluemonkey]

"COUNT field incorrect or syntax error" what is wrong ?? any ideas the sql statment is

sqlString = "INSERT INTO tblEvents (EventName, Start_Day, End_Day, Info)VALUES ('"&eventname&"', '"&startdate&"', '"&enddate&"', '"&eventdescription&"')"


thanks for the help

[arnyinc]

That's a pretty generic error, usually just a typo. What database are you using?

Should there be an underscore in Event_Name?

[ReyN]

not sure, but i think you'd need a space between the closing parenthesis and the keyword VALUES, as in

sqlString = "INSERT INTO tblEvents (EventName, Start_Day, End_Day, Info) VALUES ('"&eventname&"', '"&startdate&"', '"&enddate&"', '"&eventdescription&"')"