Expression builder

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I would like to create a field in which it is looking at another field and
saying, if the number of digits is 4, then add a "0" at the beginning, and if
the number of digits is 5, then don't do anything.

Thanks in advance!
 
Perfect! Thanks.

KARL DEWEY said:
MyField_X: IIF(Len([Field_X]) = 4, "0" & [Field_X], [Field_X])

--
Build a little, test a little.


Mike said:
I would like to create a field in which it is looking at another field and
saying, if the number of digits is 4, then add a "0" at the beginning, and if
the number of digits is 5, then don't do anything.

Thanks in advance!
Click to expand...
Click to expand...
 
Back
Top