I'm new to this forum, please forgive if this is a breach of edicate. My problem is as follows.
I have a database that I want to show in numeric order. For example
XXX 1001.1
XXX 1001.2
ect...
In my database the first 3 values are letters and remain constant. As seen above then the numbers follow. I have over 5000 entries to manage and it gets fairly frustrating when looking for entry
XXX 10120.1 and the entry that follows is XXX 1200.1, Don't know where is start to fix this problem please help

I would create a seperate column that is based on the this column and sort on it. It would be something like:

myNewCol: cdbl(right(myTextFld,len(myTextFld)-4))

Then sort on it.

Would this work?