U. S. Postal Code format

[Calymyrna]

I created a mailing list database in Access. When I printed the labels, the numbers of the postal codes + 4 are ganged together without a hyphen. For example, a code that properly reads 20101-1444 is printed 201011444. How do I insert a hyphen between the two sets of numbers in my label report? I used the label wizard. I would appreciate any help please. Thanks!

 

[theprez]

Try this,

ZipPlus4 = left([Zip Cod],5) & "-" & right([Zip Code],4)

the left command here displays the first 5 characters of the zip code field.

the right command displays the first 4 characters of the zip code field starting from the right.

You can also play with the format command.