Add a character to a field already populated

[nicoralph]

I have quite a big amount of numbers in a column, the values in this column range between 8 and 9 charactrers in length. I need to add a zero "0" to the beginning of every column that only contains 8 characters. How can I manage this?

Thanks

 

[Mile-O]

Don't directly use the table. Leave the table as it is.

Use a query.

Disregard the field you are referring to in the query and, instead, make a new field like this:

NewField: Format([MyField], "000000000")


where MyField is the name of the numeric field.

 

[nicoralph]

I have quite a big amount of numbers in a column, the values in this column range between 8 and 9 charactrers in length. I need to add a zero "0" to the beginning of every column that only contains 8 characters. How can I manage this?

Thanks

Gracias