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>