Sort/Alphabetize problem

[Guest]

I'm having a strange problem in Access. I'm sorting by a name field in a
"make table" query. The results come should come out with rows alphabetized
by the last name in the field. Instead they come out beginning with C's and
they are in alpha order down to about E's then they start over with A's and
are in alpha order to the end. IE. Instead of a list coming out A,B,C,D,E
ETC. It's coming out C,D,E,A,B,C,D,E ETC

 

[Rick Brandt]

I'm having a strange problem in Access. I'm sorting by a name field
in a "make table" query. The results come should come out with rows
alphabetized by the last name in the field. Instead they come out
beginning with C's and they are in alpha order down to about E's then
they start over with A's and are in alpha order to the end. IE.
Instead of a list coming out A,B,C,D,E ETC. It's coming out
C,D,E,A,B,C,D,E ETC

Tables have no (reliable) order so putting a sort order on a make table
query is a futile thing to do.

If you want to see your data in a reliable order you MUST use a query, form,
or report that has an explicit ORDER BY applied to it.