MS Access database number sorting trick?

That was why I recommended a separate field. Things with non-numeric values get set to or zero in such a conversion. Then it is easy to sort on the new field–and you can create your own numbering system so you can find what you want.