Missing Leading Zero on records

  • Thread starter Thread starter Denise Blum via AccessMonster.com
  • Start date Start date
D

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.
 
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.
Click to expand...

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