Sorting hyphenated or two word name
I have a problem sorting names eg, Di-Silva or Van Dorssen.Sorting them will also pick up the S and D.Is there a way that the sort only looks at the first letter ?Hansie
Thank you for your post.
When you sort by a Text field, it will start with the first character in that field.
Perhaps you are looking at the Index. Put your cursor in the field, pull down the Insert menu and select "From Index...". In that dialog box, there is a checkbox to Show individual words. This allows you to see each word in the Name field. For your example, you would see:
If unchecked, then you see the two entries:
Is this what you are referring?
Retrieving data ...