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
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