JithuAccess
Member
- Local time
- Yesterday, 17:29
- Joined
- Mar 3, 2020
- Messages
- 325
Hi,
Could you guys please let me know how do I sort Numbers correctly? In my List Box there is a field File Number and it's value is coming from a query. Though I have sorted the File Numbers in the Query, it's not displaying correctly.
In this above scenario I want to display the File Number 0140-2 just below 0140-1 but it's showing after 0140-19.
Data Type of File Number is Short Text as there are few texts too in the File Number.
Thanks
Could you guys please let me know how do I sort Numbers correctly? In my List Box there is a field File Number and it's value is coming from a query. Though I have sorted the File Numbers in the Query, it's not displaying correctly.
In this above scenario I want to display the File Number 0140-2 just below 0140-1 but it's showing after 0140-19.
Data Type of File Number is Short Text as there are few texts too in the File Number.
Thanks