How to update a filed with multiple conditions?

[luckyerdai]

I have a table, what I need to do is

if Field 1= a, field 2=b, field 3=c, then field 4 update to xxxx;
iif Field 1= a, field 2=b, field 3=d, then field 4 update to xxxxxx,
if Field 1= z, field 2=e, field 3=g, then field 4 update to xxxxxxxxx,
if Field 1= y, field 2=h, field 3=s, then field 4 update to xxxxxxxxxxx,
so on

I wold like to know how to do it in Access?

If I use Update query in Access, I need to write a lot of queries like:
Update Table Set ... Where .. ; Can Update query add condition?

Can I use VBA or ADO?

Thank you very much for your help !

[MMcCarthy]

You can do this in a query as follows:

UPDATE TableName SET [Field4]="xxxx"
WHERE [Field1]= a 
AND [Field2]=b, 
[Field3]=c;

However, for better Control you will probably need to use a recordset in VBA with nested IF statements. I am using DAO as I personally prefer it. Something like the following:

Dim db As DAO.Database
Dim rs As DAO.Recordset
 
   Set db = CurrentDb
   Set rs = db.OpenRecordset("TableName")
 
   rs.MoveFirst
   Do until rs.EOF
      If rs!Field1 = "a" Then
         If rs!Field2 = "b"  And rs!Field3 = "c" Then
            rs.Edit
            rs!Field4 = "xxxxx"
            rs.Update
         Else
            rs.Edit
            rs!Field4 = "xxx"
            rs.Update
         End If
      ElseIf rs!Field1 = "z" Then
         ' and so on
      ElseIf rs!Field1 = "y" Then
         ' and so on
      Else
         ' if none are true
      End If
      rs.MoveNext
   Loop
 
   rs.Close
   Set rs = Nothing
   Set db = Nothing
 

You just need to figure out the logic.