Nested IIF statement

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

I have a field that contains either 1, 2, or three characters. I want to add
leading 0s to the number to make all numbers three characters long. I use
this formula:

IIf(Len([parcelnumber]="1"),"-00" &
[parcelnumber],IIf(Len([parcelnumber]="2"),"-0" & [parcelnumber],"-" &
[parcelnumber]))

In every case it finds that the len = 1 and adds "-00" regardless of the
condition.


Pete Provencher
 
Figured it out but thanks anyway.

IIf(Len([parcelnumber])=1,"-00" &
[parcelnumber],IIf(Len([parcelnumber])=2,"-0" &
[parcelnumber],[parcelnumber]))





Pete Provencher
 
Instead of all that try this:

"-" & right("00" & [parcelnumber],3)

This will take 2 and make it 002, 13 and make it 013 and 136 will saty
the same.

Cheers,
Jason Lepack
 
Back
Top