Access Update Query Wizard: Multiple Criteria for same field
Posted on 2013-11-20
In my update query, I have 3 requirements:
If the Country field in the Trans table is:
USA, then Base Rate field = 11%
UK, then the Base Rate field = 12%
Canada, then the Base Rate field = 13%.
Using the query builder, I listed the the Base Rate field three times (see below). Will this work? If not, how do I do this? Thank you.
Field: Base Rate Base Rate Base Rate
Table: Trans Trans Trans
Update to: .11 .12 .13
Criteria: "USA" "UK" "Canada"