Ignore punctuation when sorting

[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

 

[Wayne Morgan]

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 "".