Update query, combine?

[kcyankees125]

I have an update query that I would like to do. Is it possible for me to have both the update "D" part and update "I" part in one query, or do I have to separate them. (Currently Access tells me that it finds characters after the end of the SQL statement

UPDATE WorldAreaCodes2 SET WorldAreaCodes2.Type = "D"
WHERE ((([WorldAreaCodes2].[Rgn Cd])=0));

UPDATE WorldAreaCodes2 SET WorldAreaCodes2.Type = "I"
WHERE ((([WorldAreaCodes2].[Rgn Cd])<>0));

 

[pbaldy]

Try

UPDATE WorldAreaCodes2 SET WorldAreaCodes2.Type = IIf([WorldAreaCodes2].[Rgn Cd]=0, "D", "I")