numbering

[loneranger27]

Hi,

I have a form with a subform. In the main form the user enters information about a product. and they enter the line number that the product appears on. I have the query that the subform is based on to sort by the line number.

My problem is that when I have line numer 10 it appears after line 1 instead of after line 9 and 11 after 10 and so on. Does anyone have any Ideas as to how I can correct this problem. I also have the same problem with a report that I have created.


I would appreciate any help you might have.

Thanks

 

[Rolliee]

Enter your line number with a

FORMAT(nn, "00000000&quot

Now the numbers are shown and sorted as '00000010' for the number 10 and '00000001' for the number 1.


Rollie E