Sorting problem in Forms and Reports

[glen]

hello all,


I have values in forms like 10,20,30,............100............
I want to sort them ascending but it show like 10,100,20..........
how to sort them properly from smallest to biggest?

Thanks.

[Missinglinq]

Your Field is defined as a Text Datatype, therefore it is already sorted in Ascending Order!

If you want it to sort like numbers would, you need to change the Datatype to Number!

Linq ;0)>

[glen]

Sorry I forgot to mention that it is a combine field. I am writing like GR 10, GR 20, GR 30...................... GR 100 but when I sort it Ascending it show GR 100 after GR 10. Regards,