OhBother30
Technical User
I am running into a little trouble sorting a text field in my database. The field contains customer names (entered last name, first name) and business names. The problem I am having is mostly with business names. I will need to produce a report that is sorted in alpha order to do an inventory on the customer files.
My report is not sorting in correct order. For example "A CUT ABOVE LAWN CARE SERVICE INC" is sorting above "AAA APPLIANCE SERVICE INC". It evedently has something to do with spaces.
Any information or advice would be appreciated. Thanks in advance!
My report is not sorting in correct order. For example "A CUT ABOVE LAWN CARE SERVICE INC" is sorting above "AAA APPLIANCE SERVICE INC". It evedently has something to do with spaces.
Any information or advice would be appreciated. Thanks in advance!