Update query question

[belsha]

I have a DB with just tables, no forms. In a table I have 5 fields, Loc1, Loc 2, Loc3, Loc4, Loc5 which are text fields. I need to update into Seg1, Seg2,...which will be number fields. Problem is that Loc 1 can be 1 of 28 choices, as can Loc 2-5. Is there any way around doing 28 individual update queries for each of the 5 fields that need to be updated? Thanks.