Problem with SQL sort (Access)

[Gerard Meijssen]

I have a table with 69472 records. One column (trinominal)
is text, 75 wide and unique. When I do a
SELECT [Full_Name].[Full_NameID], [Full_Name].[Trinominal]
INTO test
FROM Full_Name
ORDER BY [Full_Name].[Trinominal];
it does NOT sort them properly. Record 68830 has as a value
"Zygostelma gen." record 68831 has as a value
"Abromeitiella gen.". Until this record it is properly
sorted after this record is is properly sorted.

My problem is that is also affects comboboxes where the
drop down box does NOT always contain the right values (eg
when I look up trinominals that start with "Yucca"). I
think this is a bug but it makes me feel uneasy about using
Access; I do not know the extend of the problem and if it
affects the integrity of my data.
Thanks,
Gerard

 

[Van T. Dinh]

What you posted is a Make-Table Query (an Action Query), NOT a Selection
Query???

Make-Table Query makes a new Table. SELECT Query gives you a set of
returned Records.

Check Access Help on Make-Table and Select Query. They are 2 completely
different things.

If it was meant to be a Make-Table Query, repost with precise details as I
don't follow the sentence "Until this record it is properly sorted after
this record is is properly sorted" as a Make-Table query doesn't return
anything on screen!

Post the RowSource of your ComboBox also as it surely couldn't be the SQL
you posted.