Unsorted Query

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!
 
R

Rick Brandt

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

champladi

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
 
C

champladi

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
 
Top