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.

Change your field from text to number.

DOH!!

its always the simple things..

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