Simple Sort table

[Norcrossgp]

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 it in excel and it sorts correctly. Imported the table back into Access 2013 and access screws it up again. I also manually retyped the above list in a single field table and tried to sort it screws up as above. Is this a bug or am I missing something.
Norcrossgp

 

[plog]

Can you post your database? Looking at the data I haven't a clue why you are experiencing that.

 

[jdraw]

I imported your records from your post into table SortIssue and Field1

Axiall
Constangy
Conway
JF Beasley
Salter
A. Brain
A. Thomas
Acme

Ran this sort

SELECT SortIssue.Field1
FROM SortIssue
ORDER BY SortIssue.Field1;

Got this result:

A. Brain
A. Thomas
Acme
Axiall
Constangy
Conway
JF Beasley
Salter

Seems fine..

 

[Norcrossgp]

I was afraid this was a problem on my computer, guess it's time to reload Access. Thanks for responding.

 

[jdraw]

I'd suggest posting a copy of your database before reloading/installing Access.