How to ignore empty spaces when sorting records in Access

  • Thread starter Thread starter Tancuan
  • Start date Start date
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?
 
Use a calculated field that replaces them.
ShortField: Replace(Replace([YourField],"-",""),"[","")
Nest more 'Replace' for the rest.
 
Back
Top