How to format numbers in Terminal Digit Order

[maples99]

We use terminal digit order (TDO) to for our Medical Record Numbers. How can I format my report so the MRN's show in TDO?

The way we use TDO is like this:

Medical Record Number is 1234567
The first sort is 67, the second sort is 45 and the third sort is 123.

Thank you for any help you can provide me.

 

[skrandel]

just substring sort or segment the number and sort by the components.

123 is 1234567 div 10000
45 is 1234567 div 100 - ((1234567 div 10000)*10000)

This isn't exactly right, but you should get the idea.

Or just convert it to text and then substring it.

Steve Krandel
Intuit