Update Table based on If/And

[BillyDo]

Hi all

I want to run some sort of update query which will update a particular field in a table based on 2 criteria. I dont know how to write the statements in Access but it would be like this;

In TableA-

If Field A = “Red” and FieldB = <100

Then

Update Field C to “Green”

Is this possible?

Many thanks

 

[plog]

UPDATE TableA SET TableA.FieldC = "Green"
WHERE (((TableA.FieldB)<=100) AND ((TableA.FieldA)="Red"));