Tags: access, alphabetize, database, field, microsoft, mysql, oracle, query, rows, sort, sorting, sql, strange, table

Sort/Alphabetize problem

On Database » Microsoft Access

1,441 words with 1 Comments; publish: Fri, 06 Jun 2008 13:15:00 GMT; (25062.50, « »)

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

Has anyone else seen something like this?

Thanks

All Comments

Leave a comment...

  • 1 Comments
    • AccessNewbie wrote:

      > 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.

      I don't check the Email account attached

      to this message. Send instead to...

      RBrandt at Hunter dot com

      #1; Fri, 06 Jun 2008 13:16:00 GMT