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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subquery not integrating to query to display previous sum of quantities 3
Query Question 2
Query Returning Multiple Results 1
Query the brings only 0 value 5
Help with totals function in query 2
Crosstab - Calculation 3
Is it possible and how can it be done? 5
Count if query matching list 1

Back
Top