zip code formatting

[techexpressinc]

i have zips that
12345-


and
12345-1234

The problem is the dash is on the field of the 5 digit zips. So the shortest zip is 6 characters. When putting the data on reports we do not want the dash to show on the 5 digit zips. But do want it do show on the 9 digit zips.

I am not sure how to code that. I am thinking I need a new field that is created from the original and drop the dash some how.

All ideas are welcome.
Thx
Russ

[techexpressinc]

added an attachment

[weekend00]

use newzip:format(zipcode,"00000;00000")

[techexpressinc]

Weekend - i tried it and it works sometimes but not always, no rhyme or reason.
See attached.
Thx Russ

[weekend00]

That's interesting, it does remove the end hyphen, but it remove some middle hyphen.
did you get same result in every run?

[techexpressinc]

Always had the same result.

I tried this it makes sense right?

usethiszip: IIf(Len([zip]=6),Left([zip],5),[zip])

The query ran but the output was just\

#error

Still fishing for the right combo.
Rus

[weekend00]

some tiny mistake in you expression:
yours:usethiszip: IIf(Len([zip]=6),Left([zip],5),[zip])

new: usethiszip: IIf(Len([zip])=6,Left([zip],5),[zip])

[techexpressinc]

See attached.

[weekend00]

Did you get the new zip directly from [employee zip]?
I am very doubt of that. both the format function and IIf(Len([zip])=6,Left([zip],5),[zip]) were failed in same record.

you use [zip] in you expression but I saw employee zip in you attached.

[techexpressinc]

in the properties caption there is a name flipper.
Rus

[weekend00]

I did see IIf(Len([zip])=6,Left([zip],5),[zip]) in your attachment.
maybe there is some small thing that you ignored. this is a quite simple expression, I don't see any reason to get 6 from len([zip]) for zip="20005-3521".

[techexpressinc]

R u thinkin that maybe this would be better?

IIf(Len([zip])>6,[zip],Left([zip],5))

Rus

[techexpressinc]

Sometime the hyphen gets carried forward sometime not?

[weekend00]

they should be the same

if you can attach the database with the table and the query, I can take a farther look.

[techexpressinc]

IIF(Len(zip)=6, Left(zip,5),IIF(Len(zip)=9,Format(Zip,"@@@@@-@@@@"),Zip))