Where ...and .....and

[Onlylonely]

Hi All,

Appreciate if you could help me out of this.

I've no issue on below code.

If Forms!Checklist!Frame102!.Value = 1 Then

sSQL = "Update Issuetbl Set [Issuetbl].[Result] = 'Pass'  WHERE [Issuetbl].[Serial_Number] = '" & Forms!Checklist!txtSN & "' AND [Issuetbl].[Character_ID] =2"
CurrentDb.Execute (sSQL)

But for this 1, it has an data mismatch error.

If Forms!Checklist!Frame102!.Value = 1 Then

sSQL = "Update Issuetbl Set [Issuetbl].[Result] = 'Pass'  WHERE [Issuetbl].[Serial_Number] = '" & Forms!Checklist!txtSN & "' AND [Issuetbl].[Character_ID] =2 [COLOR="RED"]AND [Issuetbl].[Character_ID] =1[/COLOR]"
CurrentDb.Execute (sSQL)

 

[June7]

Even if it didn't error, no record will meet the criteria of:

Character_ID=2 AND Character_ID=1

No record can have both values.

 

[pbaldy]

And if the field is text the value needs quotes around it:

"...[Character_ID] ='2'..."