Re: Sorting w/Primary Key

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 15:40:56 -0700

On Thu, 18 Mar 2004 12:32:18 -0800, "Scott"
<anonymous@discussions.microsoft.com> wrote:

>Okay, so how would I use a query to sort column N and
>column M, without changing the order of the ID field that
>is the primary key, and extract only items based on
>a "between # and #" criteria? I guess that is the
>question I am trying to ask. Sorry. I am a little new
>at this...

It is not necessary to *sort* records in order to *select* records.
They are quite different and independent operations.

Create a Query based on your table. Put on the Criteria line

BETWEEN 1 AND 50000

on the field that you want to use as the key for extraction.

Put Ascending on the Sort row for N and for M.

You'll then get 50000 (or fewer, if there are gaps) records with the
specified range of values on the first field; those 50000 records will
be sorted in order of ascending N, and within each value of N, by
ascending M.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public