Having a problem doing a simple sort on a table. Sorting on a field containing company name and access screws up the sort order:
Axiall
Constangy
Conway
JF Beasley
Salter
A. Brain
A. Thomas
Acme
I have tried making the field a primary key, same problem, Exported the table to excel and sorted...