C
CAM
Hello,
In my query I have a text field called "Location" in this field I usually
have a single digit number or a double or triple digit number. What I want
to do is if a single digit number appears I want the field to be in four
digit: Example if a single digit number "1" appears I want "000" added to
the "1" giving "0001" or if I have a two digit number "14" I want the
field to be "0014" What I did was using a IIF statement such as
IIF([Location]="1", then "0001","") now I know there has to be a better
way. Any tips will be appreciated. Thank you in advance.
In my query I have a text field called "Location" in this field I usually
have a single digit number or a double or triple digit number. What I want
to do is if a single digit number appears I want the field to be in four
digit: Example if a single digit number "1" appears I want "000" added to
the "1" giving "0001" or if I have a two digit number "14" I want the
field to be "0014" What I did was using a IIF statement such as
IIF([Location]="1", then "0001","") now I know there has to be a better
way. Any tips will be appreciated. Thank you in advance.