I have added a number of records to a database of about 500 records in total. When I sort the base, by any field, it sorts the records in two “batches”. Less than half of them from A-Z and then the rest again from A-Z. It makes it impossible to check...
Thank you both, with your input I found a solution that works, even if it still baffles me. Eventhough there are no hidden spaces that I can see in front of the content, if I add a space and then delete it, presto the record sorts correctly! So now I...
It really is weird. I did check leading spaces and found them in one of the fields, deleting them there made that field sort right. But the three name fields have no leading spaces and still sort first 155 records, then starts over with the remaining...
