Unsorted Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I run a select query, even if I choose it to
be "not sorted", the resulting records are automaticly
sorted by the primary field values.

I am running a query that is simply a bunch of ORs of
values and I want the resulting table to be in the same
order as I originally put the values in my query.

Ex.

7 or 6 or 5 or 4

and the records returned would be

4 ...
5 ...
6 ...
7 ...

I want,

7 ...
6 ...
5 ...
4 ...

Any help on how to override this automatic sorting would
be appreciated. Thanks!
 
Whenever I run a select query, even if I choose it to
be "not sorted", the resulting records are automaticly
sorted by the primary field values.

I am running a query that is simply a bunch of ORs of
values and I want the resulting table to be in the same
order as I originally put the values in my query.

Ex.

7 or 6 or 5 or 4

and the records returned would be

4 ...
5 ...
6 ...
7 ...

I want,

7 ...
6 ...
5 ...
4 ...

Any help on how to override this automatic sorting would
be appreciated. Thanks!
Click to expand...

Most modern databases have no such thing as a built-in "order of entry".
If you want them in data entry order then you need to have a field that
reliably increments in the table with each row insertion or which records
the Date and Time of the insertion and then your query can sort on that
field.
 
wrote:
*Whenever I run a select query, even if I choose it to
be "not sorted", the resulting records are automaticly
sorted by the primary field values.

I am running a query that is simply a bunch of ORs of
values and I want the resulting table to be in the same
order as I originally put the values in my query.

Ex.

7 or 6 or 5 or 4

and the records returned would be

4 ...
5 ...
6 ...
7 ...

I want,

7 ...
6 ...
5 ...
4 ...

Any help on how to override this automatic sorting would
be appreciated. Thanks!
Click to expand...


-
champlad
 
champladi said:
* *
Click to expand...

Hi, I am having the same problem, did you manage to find a solution?
If so can you let me know. Its a bit of a pain really. cheers.

Champlad


-
champlad
 
Back
Top