Number to text with leading zero

  • Thread starter Thread starter Ralph
  • Start date Start date
R

Ralph

I am Appending a number field from one table to a text field and adding a
leading zero to another field in a different table.

Table A CaseID 940291 number field converted to
Table B CaseID 00940291 text field

Always must by 8 digits total legnth with zeros. The numbers typicallty are
5 or 6 or 7 digits long. I've inherited this and it would be preferrable not
to alter the first table structure as it is used elsewhere.

I am running Access 2007
 
I am Appending a number field from one table to a text field and adding a
leading zero to another field in a different table.

Table A CaseID 940291 number field converted to
Table B CaseID 00940291 text field

Always must by 8 digits total legnth with zeros. The numbers typicallty are
5 or 6 or 7 digits long. I've inherited this and it would be preferrable not
to alter the first table structure as it is used elsewhere.

I am running Access 2007
Click to expand...

Format([NumberField],"00000000")

will convert Number datatype 940291 to Text datatype "00940291".
 
Back
Top