Strange or wrong alphabetical order in queries tables

[JuanGmo]

I have several table with scientific names of butterflies, when I order from A to Z, in the table or in the queries, only with the letter C, i got names that start with Ch after Cz, alway Ch at the end.

Example:


Conga
Cravera
Cyclosma
Chalcone

Thanks for any help. Juan

[CJ_London]

I suspect the h is not an h, but another character that looks like an h. Depends on your font

write a short routine to check the chr numbers - something like

sub checkchar(s as string)
dim i as integer

    for i=1 to len(s)
        debug.print mid(s,i,1) & ":>>" & chrw(mid(s,i,1))
    next i

end sub

[JuanGmo]

Hi Ajax, thanks for the answer, there is not a single name with Ch that doesnt work, there are a lot of Ch that goes aftre Cy, with your suggestion I exported the whole table to Excel and Word and there it works perfectly. Thanks Juan

[CJ_London]

without real data hard to prove one way or the other. I can't replicate the problem.

Only other thought is perhaps your db has some corruption. Suggest compact/repair or better, create a new db and import all objects

Another suggestion is to reimport the data from excel and see if it now sorts correctly in Access