Topic: numbers sorting

Hi,
is there any idea how to fix sorting?

thank you

Igor

Post's attachments

Attachment icon sorting numbers.jpg 241.78 kb, 10 downloads since 2025-05-04 

Re: numbers sorting

Hi Igor,
Have a look at the attachment as an option to get round this  (thanks to Sparrow for the original suggestion from a looooong time ago! smile)
Derek.

Post's attachments

Attachment icon Igor Sorting.zip 451.64 kb, 25 downloads since 2025-05-04 

Re: numbers sorting

Hi Derek, Igor
This solution assumes that each subsequent order has a number greater than the previous one. So we can sort by ID.
However, if the sequence of orders is broken, you can apply the following solution with a calculated field. I broke the sequence in the database. A small description in the script.

Post's attachments

Attachment icon Igor Sorting m.zip 120.41 kb, 27 downloads since 2025-05-04