Insert a Dash into a Zip Code

  • Thread starter Thread starter David
  • Start date Start date
D

David

How would you write a query to insert a dash after the 5th
digit into a 9 digit zip code? ie xxxxxxxxx to xxxxx-xxxx?
This needs to be done at the table level, not the report
level.
 
Create an Update Query using the Query Designer. In the Update To: row,
insert the expression provided to you by Cameo in your earlier thread:

Format([ZipCode],"00000-0000")
 
Back
Top