How to ignore empty spaces when sorting records in Access

[Tancuan]

How do I make Microsoft Access ignore particular characters, such as
brackets, asterisks and empty spaces, when index-sorting the records in a
table?

 

[KARL DEWEY]

Use a calculated field that replaces them.
ShortField: Replace(Replace([YourField],"-",""),"[","")
Nest more 'Replace' for the rest.