Number to text with leading zero

[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

 

[fredg]

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

Format([NumberField],"00000000")

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