auto enter serial numbers

[MadHatter]

if i create a field that is an auto enter serial number, and have the number increase by 1 for every record. on the web form of this database, if i were to sort by the auto enter number then it would come out like this

1

10

11

12

13

14

...

2

20

21

and so on, so i made the auto number formed like this 0001, 0002, 0003 and so on, and the big boss guy doesnt like the 000 in front of the number, so i was wondering if i could just like block out all the 0's in that field so that only the number is left.

[dspires]

Change your field from text to number.

[MadHatter]

DOH!!

its always the simple things..

------------------