[AccessD] A2000: Multiple UPDATES in one query

Mon Feb 7 09:37:13 CST 2005

Gustav,

By jingies! I think that'll work! Thanks!

Steve Erbach

On Mon, 07 Feb 2005 15:48:21 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> Couldn't you use IIf():
> 
>  UPDATE
>    tblTest
>  SET
>    FieldToChange = IIf(FieldA = 5 AND FieldB = 6, 2, 1)
>  WHERE
>    (FieldA = 5 AND FieldB = 6)
>      OR
>    (FieldA = 2 AND FieldB = 3);
> 
> /gustav
>