Data up date with multi information in fields

[taloker]

I am using ACCESS since 2002 but so far dont have any good knowledge of VBA.

Recently I came across with a trouble when I wanted to up date data. Actually I wish to do it as follow
Field 1 Field 2 if field1 = Saloon then update Field2 to SOLD

and if Field1 = Truck then update field2 to DAMAGED (MULTI RECORDS)

I hope some one will help me
Taloker

 

[ranman256]

Vba is not needed here, just run an update query with this criteria.