[AccessD] A2000: Multiple UPDATES in one query

Steve Erbach erbachs at gmail.com
Mon Feb 7 08:33:34 CST 2005


Dear Group,

I'm converting a Paradox app to Access 2000. In the Paradox app
there's a bit of code that scans through all the records in a table
and changes the value in one field based on values in other
fields...essentially an UPDATE operation. There are only two possible
ways the data in the one field can be changed.

I thought to myself I thought, "Hey! Couldn't I just make an UPDATE
query out of this?" So I tried. But it looks to me as if one can only
UPDATE the field with one choice at a time:

UPDATE tblTest
SET FieldToChange = 2
WHERE ((FieldA = 5) AND (FieldB = 6));

But I'd also like this in the same query if possible:

UPDATE tblTest
SET FieldToChange = 1
WHERE ((FieldA = 2) AND (FieldB = 3));

Can I do that in one query? Does it take a UNION operator perhaps? I
think I'll try that.

-- 
Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security



More information about the AccessD mailing list