Issue with Group and Sort Configuration on a Report

[Sinnapz]

Okay, I have a database, in this database I have a "group and sort" set up on a report that I built from the database. The report is sorted by the "shape" field, then the "weight" field. The weight field is where I am having an issue. I have values in this field that range from .01 to 9. whatever..... nothing has ever gone over 9.*. We now have a item with a 10.* value and when access sorts the report the "10" weight item is listed at the bottom of the 1's not after the 9's. I need to have access treat the 10 as a larger number than 9 not as the end of the 1's. So right now 10 is right before it goes to 2, I need it to be after 9. Is this possible ?

Thank you for your help ahead of time

[June7]

The field is text type so sort is based on alpha heirarchy, not numerical. Change the field to number (Double) type or data must have leading zeros.


010 will sort after 009.

[Sinnapz]

Thanks a lot everything is working how I need it to!