Sorting Column Alphabetically - Unwanted sort by year also added
I have an app with data where each record is a person. I want to sort alphabetically on first name... sounds easy. You click the column header for "first name" and it appears to sort from A-Z. However, it goes from A-Z and then randomly half-way through my records it starts from A again and goes A-Z.
After much investigation it appears all records created in 2018 sorted A-Z, and then separately all 2017 records sorted A-Z independently. This makes it very hard to actually find a record based on first name.
How can this unwanted extra sort criteria be removed?
-
Was there an answer to this? I am assisting someone who has exactly the same issue.
Please sign in to leave a comment.
Comments
2 comments