Non-Numeric Sorting like Numeric

  • Thread starter Thread starter JimS
  • Start date Start date
J

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?
 
JimS said:
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?
Click to expand...

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

Tom Lake
 
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


Tom Lake said:
JimS said:
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?
Click to expand...

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

Tom Lake
Click to expand...
 
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)?
Click to expand...

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.
 
Back
Top