Leading Zeroes

[FREEEEEEDOM]

Question- I am trying to keep my leading zeroes in Access. I change the format of my AutoID in design view to "0000000" so that 1,2,3...etc would be displayed as 0000001,0000002,0000003...etc.



However, I need to combine this with another field and when I do that, the zeroes drop. I understand that the physical data is numeric, and I have tried simply changing it from AutoID data type to Text - but still no luck.

I am currently getting around the problem by copying the data in Excel, then copying it in to Notepad, then re-importing the file back into Access and changing the data type from Long Integer to Text in the Import Wizard.

Any way to solve this in Access alone?

Thanks

[thhui]

Try this:-

You can concatenate [AutoID] with [otherVar] this way:-
format([AutoID], "0000000") & [otherVar]

[RuralGuy]

Is the AutoID field an AutoNumber field? Do you know that there is no guarantee the numbers are sequential? Have you read this link? General: Use Autonumbers properly