I don&#039t know if someone already answered this, I been sick and my question was removed. Here it is again. I have a text field that I wish to order by ascending . The field contains a combination of digits and periods, this field determines where the record belongs in the hierarchy of the information that I am reporting on.<BR>Problem: I can not treat this field as numeric as in many cases it contains more than one decimal point (period) BUT.... when I try to order by the number, it does not do so as real numbers Below is a comparison of what I get to what I want.<BR>Any suggestions??? Please help me...<BR>What I want____________________ What I get<BR>1______________________________ 1<BR>1.1____________________________ 1.1<BR>1.1.1__________________________ 1.1.1<BR>1.1.2__________________________ 1.1.10<BR>1.1.3__________________________ 1.1.11<BR>1.1.4__________________________ 1.1.2<BR>1.1.5__________________________ 1.1.3<BR>1.1.6__________________________ 1.1.4<BR>1.1.7__________________________ 1.1.5<BR>