   Problem in "insert into" (VB)
  I'm doing a final high school project and I have some problems.When I'm trying to do "insert into" I see the following error:SYNTAX ERROR IN INSERT INTO STATEMENTI used a lot of time the "insert into" command during my project and all the previous times were successful.I checked if the fields and the object names identical to the table and I saw that everything is identical.I checked the strings too(with MSGBOX) and everything looks proper.Here is the code which the problem appears in:db.Execute "insert into Discounts ([info],typeName,[type],startDate,stopDate,[count],percent) values ('" & txtDisInfo & "','" & lblDisName & "'," & optType.Value & ",'" & dtStart & "','" & dtEnd & "'," & txtDisCount & "," & txtDisPercent & ")"Can anyone please recognize the problem here and why it appears?Thanking you in advance.**I use Visual Basic 6.0(Microsoft).and Access.   
  Maybe I'm just spoiled from using Oracle, but what is it with SQL implementations that don't even bother to tell you WHERE they found the syntax error? :D.You say you checked the strings... does that include checking the numerical values as well? Try running the SQL manually (i.e. no VB, just SQL prompt) with all those values and see if you run into something. It might be that one of your numerical values actually is a string, and you aren't including the single quotes (or vice versa).   ;  Thank you.I run it from the access(like you said manually from the sql) and the problem is in the work "percent", its a part of VB functions or procedures or something...and again Thank You!   