Auto Numbers 1

[blackcat9000]

Can anyone help me with this problem.

When you used the autonumber function the numbers will start 1,2,3 etc.

How do I create an autonumber so it starts 01, 02, 03

Thanks in advance

 

[ZmrAbdulla]

In the table design view
Select the field > Format = 00

Better Set it 00000 to avoid confusion after 99

Data
00001
00002
00003

Or if you want a prefix on that
"AB"00000
Data
AB00001
AB00002
AB00003

Regards




Zameer Abdulla

http://www.mtkhoory.com

http://www.aikah.com

 

[blackcat9000]

Many thanks for that tip bro. That work a treat.