Here are a couple more inline query examples that I in code - not exactly the same each time but close
I generally use the Single-record append query, not Multiple-record append queries.
1) bNo_401k - this is a boolean. lENDPK is a long integer that is the PK of an employee.
Code:
sSQL = "UPDATE employee_name_def SET employee_name_def.end_No_401k = " & bNo_401k
sSQL = sSQL & " WHERE (((employee_name_def.end_pk)=" & lENDPK & "));"
d.Execute sSQL, dbFailOnError
2) Here the "v" prefix just lets me know it is a variable. "Me" refers to a control on a form.
Code:
vEPDFK = Me.hbh_epdfk
vFringe = Me.hbh_Fringe
vBegDate = DateAdd("d", 1, vEffectiveDate)
vEndDate = DateAdd("yyyy", 50, vBegDate) - 1
sSQL = "INSERT INTO employee_fringe_def ( efd_epdfk, efd_fringe, efd_BegDate, efd_Enddate )"
sSQL = sSQL & " VALUES ( " & vEPDFK & ", " & vFringe & ", #" & vBegDate & "#, #" & vEndDate & "#)"
' Debug.Print sSQL
db.Execute sSQL, dbFailOnError