Skip to main content

How does AT sort (address) numbers that also have a suffix letter? For example, 2A, 2B, etc.


To overcome the sorting problem for addresses in a Filemaker desktop database I use, I have a separate field alongside the address number in which I enter the address number in numerical formal only and use that separate field for sorting. For example, 2.1, 2,2, etc.


tia

Answered my own question. AT sorts 2, 2B, 2A, 2C as 2, 2A, 2B, 2C.

so no need for separate field.


Reply