Hi All.
I have couple update queries for the same table:
Is it possible to combine those queries into one update query? If yes. How to do it?
Thanks.
I have couple update queries for the same table:
Code:
UPDATE Table1 SET Table1.Code = "01"
WHERE (((Table1.Code) Not In ("01","05","06","07","08")));
and
UPDATE Table1 SET Table1.ANum = Null
WHERE (((Table1.Group) Like "HC*"));
Thanks.