Missing Leading Zero on records

[Denise Blum via AccessMonster.com]

I am importing a deptid field ?0101? from an excel spreadsheet. When I
import it into the table in Access it loses the leading ?0?. How can I
create a query to ADD the ?0? back to the table record deptid.

 

[fredg]

I am importing a deptid field ?0101? from an excel spreadsheet. When I
import it into the table in Access it loses the leading ?0?. How can I
create a query to ADD the ?0? back to the table record deptid.

Access does not store leading zeros.
You can change the field datatype to Text, and update the field to add
leading zeros, but this can impact other aspects of your database.

I would suggest you simply format the field to display the leading
zeros. Set the control's Format property to:
0000

 

[Denise Blum via AccessMonster.com]

That solve my problem. THANKS!!