Ignore punctuation when sorting

  • Thread starter Thread starter Mike Revis
  • Start date Start date
M

Mike Revis

Hi Group,

Access 2000 Win XP Pro.

Is there any way to get around the default sorting of Access?

The default sorting puts "Acetic Acid Solution" before "Acetic Acid,
Glacial".

It would be nice to ignore the punctuation ( , ) and sort "Acetic Acid,
Glacial" before "Acetic Acid Solution".

As always, any suggestions or advice is welcome.

Thanks
Mike
 
If you are doing this in a query, you could create a calculated field for
sorting purposes only (don't check the Show box in the query design grid).
Use the Replace function in the calculation to remove the punctuation and
replace it with "".
 
Back
Top