Help, Sorting Query bug

From: mike (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 10:02:52 -0700

Hello, for the last two years we've been experiencing
problems with a very simple query that sorts a table and
makes a new sorted table. Once the table exceeded 100,000
records the resulting sorted table was not always sorted
correctly.

Today, I had to run the sorting query 6 times to finally
get a correctly sorted table. (access 2002, SP3 on windows
XP). About 25% of the time the table will sort correctly.

Our table has now grown to 415,000 records.

Thanks for your assistance

Relevant Pages

  • Re: Differences in Range Scan Performance between Binary and NLS Indexes
    ... And our query plan looks like this and completes in about 120 ms. ... 400 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Class reunion query
    ... (no private e-mails, please) ... This query worked, almost. ... It sorts by the first name and not the LastName/as I had ... FROM tblDemographics ...
    (microsoft.public.access.queries)
  • Re: Can a query reuse data???
    ... been committed when this current query began. ... 381 bytes received via SQL*Net from client ... sorts (memory) ... consistent gets ...
    (comp.databases.oracle.server)
  • RE: date format/sort problem
    ... There is no such thing as a Date/Time data type which only contains ... The Format propety of the field determines how the data in the field is ... In my first query I need to format it: ... This works fine and the query sorts in chronological order however when I ...
    (microsoft.public.access.queries)
  • Re: How do you maintain a sort in a sub-form?
    ... Create a query that sorts the rows in the correct order, ... as the recordsource for the form rather than the table. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.forms)