Zip+4 in an update query

[wsproperties]

I import an access table that formats the zipcode as follows: For 23225-0522. It reads 232250522. In an update query, how can I format the zip code so that if it is 9 digit, it will read 23225-0522? If it is a 5 digit zip I need it to read 23225 with no dash at the end.

 

[Golom]

UPDATE ZipTable 

SET [ZIP] = Left([ZIP],5) & "-" & Right([ZIP],4)

WHERE Len([ZIP]) = 9