+8I 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.
+35Sounds like you have a leading space before the name.
+8Good 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.
+35Good 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.