How to ignore empty spaces when sorting records in Access

T

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?
 
K

KARL DEWEY

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