Re: Is There Away to Avoid Sorting?

tanorris_at_academicplanet.com
Date: 03/27/05 

Date: Sun, 27 Mar 2005 13:25:09 -0600

But, how do you actually specify no sorting in the Query?

On Sun, 27 Mar 2005 15:46:00 GMT, "Rick Brandt"
<rickbrandt2@hotmail.com> wrote:

>tanorris@academicplanet.com wrote:
>> Is there a way to avoid sorting (Asc and Desc), including the Access
>> default sorting? I do not want any sorting to occur in a SELECT
>> query. TIA
>>
>> Tom
>
>If you specify no sorting at all explicitly then you will normally get the
>records in the order thay are retrieved from disk. In a file that is compacted
>regularly this will usually be Primary Key order. If what you want is a truly
>random order then I'm not aware of an easy way to achieve that.

Relevant Pages

  • RE: consistent error on first record
    ... > underlying table is all important. ... Sorting a table or sorting a query ... The order in a query is the only thing you ... and then only if you specify an ORDER BY clause. ...
    (microsoft.public.access.modulesdaovba)
  • Re: order by
    ... Paul, the best method is to create a query, and use the Sorting row of the query to specify the sort order you want. ... If you don't specify any sort order, Access typically presents the records in the order of their primary key, though theoretically the order is undefined. ...
    (microsoft.public.access.queries)
  • Re: Report loses sorting criteria of underlying query
    ... Sorting and Grouping report feature. ... Even if you only specify a group in Sorting and Grouping, ... determining how to sort the report. ...
    (microsoft.public.access.reports)
  • Re: Report loses sorting criteria of underlying query
    ... Sorting and Grouping report feature. ... Even if you only specify a group in Sorting and Grouping, ... determining how to sort the report. ...
    (microsoft.public.access.queries)
  • Apply DataView.Sort once, for sorting snapshot, data update should not resort
    ... Is there anyone who knows how I can use a datatable, dataview (and datagrid) ... and have the sorting that I specify, DataView.Sort="col dir", to only be ...
    (microsoft.public.dotnet.framework.adonet)