Where in SQL. 1

[lars7]

Hi Guys,

I have a Syntax error with the last bit of this code:

CurrentDb.Execute "UPDATE tblstaffCodes SET Discipline = '" & Forms!FormJobDescriptions!FormStaffLookup!Discipline & "' WHERE PayNumber = '" & Forms!FormJobDescriptions!FormStaffLookup!Text1 & "' and WHERE AdditPayNumber = 0"

I tried the ampersand and just "where" but no success :-(

AdditPayNumber is numeric

 

[rjoubert]

Take out the second "WHERE"...you don't need it. It should be... and AdditPayNumber = 0

 

[lars7]

Thanks rjoubert,

I never thought of that one.

CurrentDb.Execute "UPDATE tblstaffCodes SET Discipline = '" & Forms!FormJobDescriptions!FormStaffLookup!Discipline & "' WHERE PayNumber = '" & Forms!FormJobDescriptions!FormStaffLookup!Text1 & "' and AdditPayNumber =0"