Can someone provide the syntax, or an place I can find it, for an update query using:
Thank you!!Code:'mySQL = ("UPDATE myTable") CurrentDb.Execute mySQL, dbFailOnError
This is what I have but it isn't working...
Code:mySQL = ("UPDATE AcctPeriod SET RV = '" & varRACF & "' WHERE Auto >= '" & varBegNum & "' AND Auto <= '" & varEndNum & "'") CurrentDb.Execute mySQL, dbFailOnError