Hello,
I am trying to create an IIf function where it gets the length of the field. if it is under the length of 5 I want to add a "0" to the beginning of the field. I cannot get the query to work. It just deletes everything in the field.
UPDATE Import_Template SET Import_Template.Zip_Code = IIf(Len([Zip_Code]>5),"0"+[Zip_Code],[Zip_Code]);
I don't know what to put in as the false statement.