Whay am I getting a syntax error and how do I fix it?

SQL = "INSERT INTO application
(clientrecordid,applegalname,appoperatingname,appaddress1,appcity,appprovince,apppc,appcontacttitle,"
_
     & "appph,appfax,appmobile,appcontactemail,appwebsite,appbustype,appbusage,appcorpage,appbusdesc,appbank,appbankaddress,"
_
     & "appbankcontact,appbankph,appbankfax,appbankacctnum,appequipdesc1,appequipdesc2,appequipcost,appprinfn,appprinmn,appprinln,"
_
     & "appprinaddress1,appprincity,appprinprovince,appprinpc,appprindob,appprinsin,appprinhomeph,appprinownorrent,appprinmthlypmt,"
_
     & "appprinmtgbal,appprinhomeval,appprinemployer,appprinposition,appprinmthlyinc,appprinyrsemp,appprinempph,appcontactfullname,"
_
     & "appprimaryprincipalrecordid,apppfscash,apppfsrrsp,apppfsrealestatetotal,apppfsvehicletotal,apppfstotalassets,apppfsrealestateloans,"
_
     & "apppfsotherloans,apppfstaxes,apppfsotherliab1,apppfsotherliab2,apppfsliabtotal,apppfsnetworthtotal,apppfsrrspdesc1,"
_
     & "apppfsrrspwhereheld1,apppfsrrspdesc2,apppfsrrspwhereheld2,apppfspropertyaddress1,apppfstitleinnameof1,apppfsmarketvalue1,"
_
     & "apppfsowing1,apppfspmt1,apppfsincome1,apppfsdateofpurchase1,apppfsorigpurchamt1,apppfspropertyaddress2,apppfstitleinnameof2,"
_
     & "apppfsmarketvalue2,apppfsowing2apppfspmt2,apppfsincome2,apppfsdateofpurchase2,apppfsorigpurchamt2,apppfspropertyaddress3,"
_
     & "apppfstitleinnameof3,apppfsmarketvalue3,apppfsowing3,apppfspmt3,apppfsincome3,apppfsdataofpurchase3,apppfsorigpurchamt3,"
_
     & "apppfsmakeofvehicle1,apppfsmodelofvehicle1,apppfsyrofvehicle1,apppfsdollarvalueofvehcile1,apppfsmakeofvehicle2,apppfsmodelofvehicle2,"
_
     & "apppfsyrofvehicle2,apppfsdollarvalueofvehicle2,apppfsmakeofvehicle3,apppfsmodelofvehicle3,apppfsyrofvehicle3,"
_
     & "apppfsdollarvalueofvehicle3,apppfsbank1,apppfsbankph1,apppfsamtowing1,apppfsbankpmt1,apppfsbank2,apppfsbankph2,apppfsamtowing2,"
_
     & "apppfsbankpmt2,apppfsbank3,apppfsbankph3,apppfsamtowing3,apppfsbankpmt3,apppfsempincome,apppfsrentalincome,apppfsotherincome1,"
_
     & "apppfsotherincome2,apppfsincometotal,apppfsrentormtgpmt,apppfsgenerallivingexp,apppfsloanpmts,apppfsotherexp,apppfscashsurplus,"
_
     & "apppfstotalexp,apppfsotherassets)" _
     & " VALUES ("

sSQL = rSQL & "" & clientrecordid & ",'" & applegalname & "','" &
appoperatingname & "','" & appaddress1 & "',"
sSQL = sSQL & "'" & appcity & "','" & appprovince & "','" & apppc &
"','" & appcontacttitle & "','" & appph & "','" & appfax & "',"
sSQL = sSQL & "'" & appmobile & "','" & appcontactemail & "','" &
appwebsite & "','" & appbustype & "',"
sSQL = sSQL & "'" & appbusage & "','" & appcorpage & "','" &
appbusdesc & "','" & appbank & "','" & appbankaddress & "',"
sSQL = sSQL & "'" & appbankcontact & "','" & appbankph & "','" &
appbankfax & "','" & appbankacctnum & "," & appequipdesc1 & "',"
sSQL = sSQL & "'" & appequipdesc2 & "'," & appequipcost & ",'" &
appprinfn & "','" & appprinmn & "','" & appprinln & "',"
sSQL = sSQL & "'" & appprinaddress1 & "','" & appprincity & "','" &
appprinprovince & "','" & appprinpc & "','" & appprindob & "',"
sSQL = sSQL & "'" & appprinsin & "','" & appprinhomeph & "','" &
appprinownorrent & "'," & appprinmthlypmt & ","
sSQL = sSQL & "" & appprinmtgbal & "," & appprinhomeval & ",'" &
appprinemployer & "','" & appprinposition & "',"
sSQL = sSQL & "" & appprinmthlyinc & "," & appprinyrsemp & ",'" &
appprinempph & "','" & appcontactfullname & "',"
sSQL = sSQL & "" & appprimaryprinciRpalrecordid & "," & apppfscash &
"," & apppfsrrsp & "," & apppfsrealestatetotal & ","
sSQL = sSQL & "" & apppfsvehicletotal & "," & apppfstotalassets & ","
& apppfsrealestateloans & "," & apppfsotherloans & ","
sSQL = sSQL & "" & apppfstaxes & "," & apppfsotherliab1 & "," &
apppfsotherliab2 & "," & apppfsliabtotal & ","
sSQL = sSQL & "" & apppfsnetworthtotal & ",'" & apppfsrrspdesc1 &
"','" & apppfsrrspwhereheld1 & "','" & apppfsrrspdesc2 & "',"
sSQL = sSQL & "'" & apppfsrrspwhereheld2 & "','" &
apppfspropertyaddress1 & "','" & apppfstitleinnameof1 & "',"
sSQL = sSQL & "" & apppfsmarketvalue1 & "," & apppfsowing1 & "," &
apppfspmt1 & "," & apppfsincome1 & ","
sSQL = sSQL & "" & apppfsdateofpurchase1 & "," & apppfsorigpurchamt1 &
",'" & apppfspropertyaddress2 & "',"
sSQL = sSQL & "'" & apppfstitleinnameof2 & "'," & apppfsmarketvalue2 &
"," & apppfsowing2 & "," & apppfspmt2 & "," & apppfsincome2 & ","
sSQL = sSQL & "" & apppfsdateofpurchase2 & "," & apppfsorigpurchamt2 &
",'" & apppfspropertyaddress3 & "',"
sSQL = sSQL & "'" & apppfstitleinnameof3 & "'," & apppfsmarketvalue3 &
"," & apppfsowing3 & "," & apppfspmt3 & ","
sSQL = sSQL & "" & apppfsincome3 & "," & apppfsdataofpurchase3 & "," &
apppfsorigpurchamt3 & ",'" & apppfsmakeofvehicle1 & "',"
sSQL = sSQL & "'" & apppfsmodelofvehicle1 & "'," & apppfsyrofvehicle1
& "," & apppfsdollarvalueofvehcile1 & ","
sSQL = sSQL & "'" & apppfsmakeofvehicle2 & "','" &
apppfsmodelofvehicle2 & "'," & apppfsyrofvehicle2 & ","
sSQL = sSQL & "" & apppfsdollarvalueofvehicle2 & ",'" &
apppfsmakeofvehicle3 & "','" & apppfsmodelofvehicle3 & "',"
sSQL = sSQL & "" & apppfsyrofvehicle3 & "," &
apppfsdollarvalueofvehicle3 & ",'" & apppfsbank1 & "','" &
apppfsbankph1 & "',"
sSQL = sSQL & "" & apppfsamtowing1 & "," & apppfsbankpmt1 & ",'" &
apppfsbank2 & "','" & apppfsbankph2 & "',"
sSQL = sSQL & "" & apppfsamtowing2 & "," & apppfsbankpmt2 & ",'" &
apppfsbank3 & "','" & apppfsbankph3 & "',"
sSQL = sSQL & "" & apppfsamtowing3 & "," & apppfsbankpmt3 & "," &
apppfsempincome & "," & apppfsrentalincome & ","
sSQL = sSQL & "" & apppfsotherincome1 & "," & apppfsotherincome2 & ","
& apppfsincometotal & "," & apppfsrentormtgpmt & ","
sSQL = sSQL & "" & apppfsgenerallivingexp & "," & apppfsloanpmts & ","
& apppfsotherexp & "," & apppfscashsurplus & ","
sSQL = sSQL & "" & apppfstotalexp & "," & apppfsotherassets & ")"

Hi

Try this.

ssql = "INSERT INTO application
(clientrecordid,applegalname,appoperatingname,appaddress1,appcity,appprovince,apppc,appcontacttitle,"
_
 & "appph,appfax,appmobile,appcontactemail,appwebsite,appbustype,appbusage,appcorpage,appbusdesc,appbank,appbankaddress,"
_
& "appbankcontact,appbankph,appbankfax,appbankacctnum,appequipdesc1,appequipdesc2,appequipcost,appprinfn,appprinmn,appprinln,"
_
& "appprinaddress1,appprincity,appprinprovince,appprinpc,appprindob,appprinsin,appprinhomeph,appprinownorrent,appprinmthlypmt,"
_
& "appprinmtgbal,appprinhomeval,appprinemployer,appprinposition,appprinmthlyinc,appprinyrsemp,appprinempph,appcontactfullname,"
_
& "appprimaryprincipalrecordid,apppfscash,apppfsrrsp,apppfsrealestatetotal,apppfsvehicletotal,apppfstotalassets,apppfsrealestateloans,"
_
& "apppfsotherloans,apppfstaxes,apppfsotherliab1,apppfsotherliab2,apppfsliabtotal,apppfsnetworthtotal,apppfsrrspdesc1,"
_
& "apppfsrrspwhereheld1,apppfsrrspdesc2,apppfsrrspwhereheld2,apppfspropertyaddress1,apppfstitleinnameof1,apppfsmarketvalue1,"
_
& "apppfsowing1,apppfspmt1,apppfsincome1,apppfsdateofpurchase1,apppfsorigpurchamt1,apppfspropertyaddress2,apppfstitleinnameof2,"
_
& "apppfsmarketvalue2,apppfsowing2apppfspmt2,apppfsincome2,apppfsdateofpurchase2,apppfsorigpurchamt2,apppfspropertyaddress3,"
_
& "apppfstitleinnameof3,apppfsmarketvalue3,apppfsowing3,apppfspmt3,apppfsincome3,apppfsdataofpurchase3,apppfsorigpurchamt3,"
_
 & "apppfsmakeofvehicle1,apppfsmodelofvehicle1,apppfsyrofvehicle1,apppfsdollarvalueofvehcile1,apppfsmakeofvehicle2,apppfsmodelofvehicle2,"
_
& "apppfsyrofvehicle2,apppfsdollarvalueofvehicle2,apppfsmakeofvehicle3,apppfsmodelofvehicle3,apppfsyrofvehicle3,"
_
& "apppfsdollarvalueofvehicle3,apppfsbank1,apppfsbankph1,apppfsamtowing1,apppfsbankpmt1,apppfsbank2,apppfsbankph2,apppfsamtowing2,"
_
& "apppfsbankpmt2,apppfsbank3,apppfsbankph3,apppfsamtowing3,apppfsbankpmt3,apppfsempincome,apppfsrentalincome,apppfsotherincome1,"
_
& "apppfsotherincome2,apppfsincometotal,apppfsrentormtgpmt,apppfsgenerallivingexp,apppfsloanpmts,apppfsotherexp,apppfscashsurplus,"
_
 & "apppfstotalexp,apppfsotherassets)" _
& " VALUES (" & clientrecordid & ",'" & applegalname & "','" &
appoperatingname & "','" & appaddress1 & "'," & "'" & appcity & "','"
& appprovince & "','" & apppc & "','" & appcontacttitle & "','" &
appph & "','" & appfax & "'," & "'" & appmobile & "','" &
appcontactemail & "','" & appwebsite & "','" & appbustype & "'," & "'"
& appbusage & "','" & appcorpage & "','" & appbusdesc & "','" &
appbank & "','" & appbankaddress & "'," & "'" & appbankcontact & "','"
& appbankph & "','" & appbankfax & "','" & appbankacctnum & "," &
appequipdesc1 & "'," & "'" & appequipdesc2 & "'," & appequipcost &
",'" & appprinfn & "','" & appprinmn & "','" & appprinln & "'," & "'"
& appprinaddress1 & "','" & appprincity & "','" & appprinprovince &
"','" & appprinpc & "','" & appprindob & "'," & "'" & appprinsin &
"','" & appprinhomeph & "','" & appprinownorrent & "'," &
appprinmthlypmt & "," & "" & appprinmtgbal & "," & appprinhomeval &
",'" & appprinemployer & "','" & appprinposition & "',"
ssql = ssql & "" & appprinmthlyinc & "," & appprinyrsemp & ",'" &
appprinempph & "','" & appcontactfullname & "'," & "" &
appprimaryprinciRpalrecordid & "," & apppfscash & "," & apppfsrrsp &
"," & apppfsrealestatetotal & "," & "" & apppfsvehicletotal & "," &
apppfstotalassets & "," & apppfsrealestateloans & "," &
apppfsotherloans & "," & "" & apppfstaxes & "," & apppfsotherliab1 &
"," & apppfsotherliab2 & "," & apppfsliabtotal & "," & "" &
apppfsnetworthtotal & ",'" & apppfsrrspdesc1 & "','" &
apppfsrrspwhereheld1 & "','" & apppfsrrspdesc2 & "'," & "'" &
apppfsrrspwhereheld2 & "','" & apppfspropertyaddress1 & "','" &
apppfstitleinnameof1 & "'," & "" & apppfsmarketvalue1 & "," &
apppfsowing1 & "," & apppfspmt1 & "," & apppfsincome1 & "," & "" &
apppfsdateofpurchase1 & "," & apppfsorigpurchamt1 & ",'" &
apppfspropertyaddress2 & "'," & "'" & apppfstitleinnameof2 & "'," &
apppfsmarketvalue2 & "," & apppfsowing2 & "," & apppfspmt2 & "," &
apppfsincome2 & ","
ssql = ssql & "" & apppfsdateofpurchase2 & "," & apppfsorigpurchamt2 &
",'" & apppfspropertyaddress3 & "'," & "'" & apppfstitleinnameof3 &
"'," & apppfsmarketvalue3 & "," & apppfsowing3 & "," & apppfspmt3 &
"," & "" & apppfsincome3 & "," & apppfsdataofpurchase3 & "," &
apppfsorigpurchamt3 & ",'" & apppfsmakeofvehicle1 & "'," & "'" &
apppfsmodelofvehicle1 & "'," & apppfsyrofvehicle1 & "," &
apppfsdollarvalueofvehcile1 & "," & "'" & apppfsmakeofvehicle2 & "','"
& apppfsmodelofvehicle2 & "'," & apppfsyrofvehicle2 & "," & "" &
apppfsdollarvalueofvehicle2 & ",'" & apppfsmakeofvehicle3 & "','" &
apppfsmodelofvehicle3 & "'," & "" & apppfsyrofvehicle3 & "," &
apppfsdollarvalueofvehicle3 & ",'" & apppfsbank1 & "','" &
apppfsbankph1 & "'," & "" & apppfsamtowing1 & "," & apppfsbankpmt1 &
",'" & apppfsbank2 & "','" & apppfsbankph2 & "'," & "" &
apppfsamtowing2 & "," & apppfsbankpmt2 & ",'" & apppfsbank3 & "','" &
apppfsbankph3 & "'," & "" & apppfsamtowing3 & "," & apppfsbankpmt3 &
","
ssql = ssql & apppfsempincome & "," & apppfsrentalincome & "," & "" &
apppfsotherincome1 & "," & apppfsotherincome2 & "," &
apppfsincometotal & "," & apppfsrentormtgpmt & "," & "" &
apppfsgenerallivingexp & "," & apppfsloanpmts & "," & apppfsotherexp &
"," & apppfscashsurplus & "," & "" & apppfstotalexp & "," &
apppfsotherassets & ")"

msgbox ssql

thanks
bala

This didn't seem to work.  Produces a runtime Syntax Error at or near
"," at character 2357.

We wanted to have the 'static sSQL portion (the first half) stored as
rSQL to save time during a loop.

It seems to be something happening where we add the second sSQL such as:

sSQL = sSQL & "'" & appcity & "','".....

Any other ideas?

You mean like this.. the first part value stored ssql and second part
stored in rsql.


ssql = "INSERT INTO application
(clientrecordid,applegalname,appoperatingname,appaddress1,appcity,appprovince,apppc,appcontacttitle,"
_
 & "appph,appfax,appmobile,appcontactemail,appwebsite,appbustype,appbusage,appcorpage,appbusdesc,appbank,appbankaddress,"
_
& "appbankcontact,appbankph,appbankfax,appbankacctnum,appequipdesc1,appequipdesc2,appequipcost,appprinfn,appprinmn,appprinln,"
_
& "appprinaddress1,appprincity,appprinprovince,appprinpc,appprindob,appprinsin,appprinhomeph,appprinownorrent,appprinmthlypmt,"
_
& "appprinmtgbal,appprinhomeval,appprinemployer,appprinposition,appprinmthlyinc,appprinyrsemp,appprinempph,appcontactfullname,"
_
& "appprimaryprincipalrecordid,apppfscash,apppfsrrsp,apppfsrealestatetotal,apppfsvehicletotal,apppfstotalassets,apppfsrealestateloans,"
_
& "apppfsotherloans,apppfstaxes,apppfsotherliab1,apppfsotherliab2,apppfsliabtotal,apppfsnetworthtotal,apppfsrrspdesc1,"
_
& "apppfsrrspwhereheld1,apppfsrrspdesc2,apppfsrrspwhereheld2,apppfspropertyaddress1,apppfstitleinnameof1,apppfsmarketvalue1,"
_
& "apppfsowing1,apppfspmt1,apppfsincome1,apppfsdateofpurchase1,apppfsorigpurchamt1,apppfspropertyaddress2,apppfstitleinnameof2,"
_
& "apppfsmarketvalue2,apppfsowing2apppfspmt2,apppfsincome2,apppfsdateofpurchase2,apppfsorigpurchamt2,apppfspropertyaddress3,"
_
& "apppfstitleinnameof3,apppfsmarketvalue3,apppfsowing3,apppfspmt3,apppfsincome3,apppfsdataofpurchase3,apppfsorigpurchamt3,"
_
 & "apppfsmakeofvehicle1,apppfsmodelofvehicle1,apppfsyrofvehicle1,apppfsdollarvalueofvehcile1,apppfsmakeofvehicle2,apppfsmodelofvehicle2,"
_
& "apppfsyrofvehicle2,apppfsdollarvalueofvehicle2,apppfsmakeofvehicle3,apppfsmodelofvehicle3,apppfsyrofvehicle3,"
_
& "apppfsdollarvalueofvehicle3,apppfsbank1,apppfsbankph1,apppfsamtowing1,apppfsbankpmt1,apppfsbank2,apppfsbankph2,apppfsamtowing2,"
_
& "apppfsbankpmt2,apppfsbank3,apppfsbankph3,apppfsamtowing3,apppfsbankpmt3,apppfsempincome,apppfsrentalincome,apppfsotherincome1,"
_
& "apppfsotherincome2,apppfsincometotal,apppfsrentormtgpmt,apppfsgenerallivingexp,apppfsloanpmts,apppfsotherexp,apppfscashsurplus,"
_
 & "apppfstotalexp,apppfsotherassets)" _
& " VALUES ("
rsql = rsql & "'" & clientrecordid & "','" & applegalname & "','"
rsql = rsql & appoperatingname & "','" & appaddress1 & "'," & "'"
rsql = rsql & appcity & "','" & appprovince & "','" & apppc & "','"
rsql = rsql & appcontacttitle & "','" & appph & "','"
rsql = rsql & appfax & "'," & "'" & appmobile & "','"
rsql = rsql & appcontactemail & "','" & appwebsite & "','"
rsql = rsql & appbustype & "'," & "'" & appbusage & "','"
rsql = rsql & appcorpage & "','" & appbusdesc & "','"
rsql = rsql & appbank & "','" & appbankaddress & "',"
rsql = rsql & "'" & appbankcontact & "','" & appbankph & "','"
rsql = rsql & appbankfax & "','" & appbankacctnum & ","
rsql = rsql & appequipdesc1 & "'," & "'" & appequipdesc2 & "',"
rsql = rsql & appequipcost & ",'" & appprinfn & "','" & appprinmn & "','"
rsql = rsql & appprinln & "'," & "'" & appprinaddress1 & "','"
rsql = rsql & appprincity & "','" & appprinprovince & "','"
rsql = rsql & appprinpc & "','" & appprindob & "',"
rsql = rsql & "'" & appprinsin & "','" & appprinhomeph & "','"
rsql = rsql & appprinownorrent & "'," & appprinmthlypmt & "," & ""
rsql = rsql & appprinmtgbal & "," & appprinhomeval & ",'"
rsql = rsql & appprinemployer & "','" & appprinposition & "',"
rsql = rsql & "" & appprinmthlyinc & "," & appprinyrsemp & ",'"
rsql = rsql & appprinempph & "','" & appcontactfullname & "',"
rsql = rsql & "" & appprimaryprinciRpalrecordid & "," & apppfscash & ","
rsql = rsql & apppfsrrsp & "," & apppfsrealestatetotal & "," & ""
rsql = rsql & apppfsvehicletotal & "," & apppfstotalassets & ","
rsql = rsql & apppfsrealestateloans & "," & apppfsotherloans & ","
rsql = rsql & "" & apppfstaxes & "," & apppfsotherliab1 & ","
rsql = rsql & apppfsotherliab2 & "," & apppfsliabtotal & "," & ""
rsql = rsql & apppfsnetworthtotal & ",'" & apppfsrrspdesc1 & "','"
rsql = rsql & apppfsrrspwhereheld1 & "','" & apppfsrrspdesc2 & "',"
rsql = rsql & "'" & apppfsrrspwhereheld2 & "','" & apppfspropertyaddress1 & "','"
rsql = rsql & apppfstitleinnameof1 & "'," & "" & apppfsmarketvalue1 & ","
rsql = rsql & apppfsowing1 & "," & apppfspmt1 & "," & apppfsincome1 & ","
rsql = rsql & "" & apppfsdateofpurchase1 & "," & apppfsorigpurchamt1 & ",'"
rsql = rsql & apppfspropertyaddress2 & "'," & "'" & apppfstitleinnameof2 & "',"
rsql = rsql & apppfsmarketvalue2 & "," & apppfsowing2 & "," & apppfspmt2 & ","
rsql = rsql & apppfsincome2 & "," & "" & apppfsdateofpurchase2 & ","
rsql = rsql & apppfsorigpurchamt2 & ",'" & apppfspropertyaddress3 & "',"
rsql = rsql & "'" & apppfstitleinnameof3 & "'," & apppfsmarketvalue3 & ","
rsql = rsql & apppfsowing3 & "," & apppfspmt3 & "," & "" & apppfsincome3 & ","
rsql = rsql & apppfsdataofpurchase3 & "," & apppfsorigpurchamt3 & ",'"
rsql = rsql & apppfsmakeofvehicle1 & "'," & "'" & apppfsmodelofvehicle1 & "',"
rsql = rsql & apppfsyrofvehicle1 & "," & apppfsdollarvalueofvehcile1 & "," & "'"
rsql = rsql & apppfsmakeofvehicle2 & "','" & apppfsmodelofvehicle2 & "',"
rsql = rsql & apppfsyrofvehicle2 & "," & "" & apppfsdollarvalueofvehicle2 & ",'"
rsql = rsql & apppfsmakeofvehicle3 & "','" & apppfsmodelofvehicle3 & "'," & ""
rsql = rsql & apppfsyrofvehicle3 & "," & apppfsdollarvalueofvehicle3 & ",'"
rsql = rsql & apppfsbank1 & "','" & apppfsbankph1 & "'," & "" &
apppfsamtowing1 & ","
rsql = rsql & apppfsbankpmt1 & ",'" & apppfsbank2 & "','" & apppfsbankph2 & "',"
rsql = rsql & "" & apppfsamtowing2 & "," & apppfsbankpmt2 & ",'" &
apppfsbank3 & "','"
rsql = rsql & apppfsbankph3 & "'," & "" & apppfsamtowing3 & ","
rsql = rsql & apppfsbankpmt3 & "," & apppfsempincome & ","
rsql = rsql & apppfsrentalincome & "," & "" & apppfsotherincome1 & ","
rsql = rsql & apppfsotherincome2 & "," & apppfsincometotal & ","
rsql = rsql & apppfsrentormtgpmt & "," & "" & apppfsgenerallivingexp & ","
rsql = rsql & apppfsloanpmts & "," & apppfsotherexp & "," & apppfscashsurplus & ","
rsql = rsql & "" & apppfstotalexp & "," & apppfsotherassets & ")"

ssql = ssql & rsql

thanks
bala