Sorting field with alpha numeric data

I'm using Access 2000 and I have a field which contains sample data as
follows: 4, 101 a-d, 54-56 6(a,b,c), 99, 104, 249a&249b and data type
assigned to this field is text. Since this field combines text and numbers,
is there anyway to sort this data in ascending order, also as its text field
4 comes after 39, I found that I should replace it with 04 , is there any
other method to sort this data numerically in perfect ascending order.

saggyaccess

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Sorting Problem in Report
    ... That is a proper sort for a text field that is storing number characters. ... You must set the sort order in the report. ... ascending order. ...
    (microsoft.public.access.gettingstarted)
  • Re: Exracting numerical data.
    ... Based on your sample data - if it is all in one column (but with rows ... irregularly between them) - then I would select the whole column and "Sort". ... I know there are available add-in user functions based on a loop ... The irregular spacing is for real. ...
    (microsoft.public.excel)
  • Re: Browsing the newly messed up Archive.org (continued)
    ... Orlando Enrique Fiol wrote: ... This gives you all the shows from that year in ascending order, ... That then grays out the same sort by ... I ain't a friend to change." ...
    (rec.music.gdead)
  • Sort and then cut records to Cut records and then sort
    ... cut out the records first and then sort them in ascending order. ... out the following code but fail to item into items code. ... sort in ascending order first, and then cut the records out ...
    (microsoft.public.outlook.program_vba)
  • Re: solution to evolution problem
    ... topmost). ... in ascending order so you don't have to read your ... threads backwards. ... I do sort in logical chronological order (oldest ...
    (Fedora)