Sorting a Repeating group by Item #

I am trying to sort a repeating group based on items #s (Ascending). I have items 1-110 for example, and when I choose to sort by ascending order (I assume is selecting “no” for descending), it sorts by first digit and not the complete number.

For example, the order it chooses is, 1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, etc…

I have seen a lot of post about sorting based on events changing but nothing about sorting by a whole number and not first digit. I assume this is very easy and I am just missing a click on a box however, I have spent plenty of time on this and know when its time to ask for help.

Any help is greatly appreciated!
Thank you

Can you take some screen shots of your logic on your repeating group?

I’m assuming these values are in your database, and you’re searching for them correct?

Sounds like your item number is stored as text. If you change it to type number it will sort in numerical order.


I swear I checked this but this was it, thank you!

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.