IIF STATEMENT

[99Chuck99]

I have a facility number that might have 3 digits, If so I would like to append leading zeros to make all consitant as 5 digits this is what I have been working with, but no Luck. Any assitance would be greatly appricaited.

test: IIf(Len([Facility]=3),Format([Facility],"00000"),[facility])

 

[JoeAtWork]

Looks like your first closing bracket is in the wrong place:

IIf(Len([Facility][COLOR=red])[/color]=3,Format([Facility],"00000"),[facility])

 

[lespaul]

Why would you want to format it as a constant five digits only if the length is 3? What if it's 2 or 4? Why not:

Format([Facility], "00000")

that way it's ALWAYS five not matter what the length is....




Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[JoeAtWork]

Good point, Leslie.