'Error msg : Number of query values and destination fields are not the same

this is a piece of my code :

strSQL = "INSERT INTO [Available workfront_tmp] (Subsystem, [Tag Number], ITR, Pending, Completed) VALUES " & _
             "('" & rcrd!Subsystem & "', '" & rcrd![Tag Number] & "', '" & rcrd!ITR & "', " & Pending & ", " & (Total - Pending) / Total & ");"
    DoCmd.SetWarnings False
    DoCmd.RunSQL strSQL
    DoCmd.SetWarnings True
    rcrd.MoveNext

every time a run my code i have this msg error that pop up : number of query values and destination fields are not the same

I have no idea what's wrong , i could really use some help

sqlvbams-access-2010


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions