Conditional Character Count/Format

[NeonSky via AccessMonster.com]

Good Day,

Please consider my sample records below......

FieldX
345
6792
56794

Desired Output......

FieldX
000000345
000006792
000056794

As you can see what I would like to do is append "X" number of "0" characters
to the begining of the strings found in field X, where the total string
length will equal nine total characters.

Any thoughts?

Thank you for your time!

 

[NeonSky via AccessMonster.com]

Sort of figured this out. I counted the length of "FieldX" by creating a
field in my query with the following function, "FieldXLength:len([FieldX]).
This created a new field that counted the number of characters in field x.
Next I just ran separate update statements that referenced the count and
appended zeros accordingly. Thanks!

 

[Clifford Bass]

Hi,

You can just use Format([FieldX], "000000000"). Much easier.

Clifford Bass

Sort of figured this out. I counted the length of "FieldX" by creating a
field in my query with the following function, "FieldXLength:len([FieldX]).
This created a new field that counted the number of characters in field x.
Next I just ran separate update statements that referenced the count and
appended zeros accordingly. Thanks!

Good Day,

Please consider my sample records below......

FieldX
345
6792
56794

Desired Output......

FieldX
000000345
000006792
000056794

As you can see what I would like to do is append "X" number of "0" characters
to the begining of the strings found in field X, where the total string
length will equal nine total characters.

Any thoughts?

Thank you for your time!