update query syntax (many updates)

[Guest]

Is there any way to do several updates on a single column within one update
query?

For example"

update table set column1=1 where xyz='a', column1=2 where xyz='b', column1=3
where xyz = 'c'

RICK

 

[David F Cox]

It is only one update to each field, but you can choose which update to do.
I realise that you are trying to do that, but I there are other readers.
something like:

IIF( xyz='a', 1, IIF( 'xyz' = "b", 2 , IIF ( xyz = 'c', 3, "something
else")))

if it really is "a", "b", "c" you are testing for and 1,2,3 you want you can
also use INSTR( "abc",[xyz])

 

[Duane Hookom]

David has a good answer for a limited amount of values. Either way, I would
probably create a small lookup table:

tblConversion
=================
xyz text primary key with values a, b, c
Col1 numeric with values 1, 2, 3

Create an update query with this table and your table joining the xyz
fields. Update column1 with Col1.