How do I keep a correct sequence in an append query?

[Guest]

I have a sequence of append queries I run. Each one of them has a descending
sort on a numeric field. After I complete the second and subsequent queries,
the sequence is not keep in the order I would expect and in fact every time
it seems to be a random result. I would expect:

6
5
4
3
2
1

The first query always works and each one always works on its own. But when
I append the results of the second query to the first I may get something
like this:

3
5
4
2
6
1

The results are always erratic meaning when I run the queries each time they
can be different. What am I doing wrong?

I want to note that I do the same thing except with a series of queries on
which the sort is on an alphabetic field instead of numeric. The sequence I
expect always works out on these.

 

[John W. Vinson]

What am I doing wrong?

Assuming that there is some meaning to "the order of records in a
table". There isn't.

A Table - no matter how it's filled - is an unordered "bag" of
records. If you want to see those records in some particular order,
you must - no option - use a Query sorting by a field in the table.

John W. Vinson [MVP]