Non-Numeric Sorting like Numeric

[JimS]

I have a column called "Document Nbr", which, or course, can include a
non-numeric suffix ("1325A", or "2239XY"). There must be a clean, elegant way
to sort this "number" numerically in a convenient way. Ideas?

 

[Tom Lake]

I have a column called "Document Nbr", which, or course, can include a
non-numeric suffix ("1325A", or "2239XY"). There must be a clean, elegant way
to sort this "number" numerically in a convenient way. Ideas?

In the query, create a calculated field = Val([Document Nbr]),
make it invisible and sort on that.

Tom Lake

 

[JimS]

Thanks, Tom, that strategy worked in the query, but for some reason, doesn't
work in the "order-by" property of the form. Any ideas (A2007)?
--
Jim

I have a column called "Document Nbr", which, or course, can include a
non-numeric suffix ("1325A", or "2239XY"). There must be a clean, elegant way
to sort this "number" numerically in a convenient way. Ideas?

In the query, create a calculated field = Val([Document Nbr]),
make it invisible and sort on that.

Tom Lake

 

[John W. Vinson]

Thanks, Tom, that strategy worked in the query, but for some reason, doesn't
work in the "order-by" property of the form. Any ideas (A2007)?

Base the Form on a query including a calculated field using the Val()
function, and use THAT field (along with the text field as a secondary sort)
in the OrderBy.