I have the primary key column with a single line text field of venues. When I attempt to sort them in ascending order 1 record won’t sort correctly.
Cate’s Place, South Australia
– is sorting before
Adelaide Recording Studios, South Australia.
All the other records after this are sorting perfectly.
I’ve even tried removing the apostrophe, but that didn’t change anything.
Sounds like you have a leading space before the name.
Good catch ScottWorld, I did a copy / paste from the website. It looked like it was inline with the other text. Thanks for the reply / quick fix.
Good catch ScottWorld, I did a copy / paste from the website. It looked like it was inline with the other text. Thanks for the reply / quick fix.
You’re welcome! Glad I could help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.