Filter changes order of records

[Guest]

Every time I run filter by selection it displays records in different order.
There is no indication of any kind of sorting anywhere. I set Advanced filter
to "Not Sorted". But it is happening anyway. I tried to analyse the data but
there seems to be no specific order in any field that could indicate sorting.
What could it be? Any ideas?

 

[Tom Ellison]

Dear Curious:

When you don't choose to sort the data in a query, then you don't get to
complain about the order you receive. It can be in any order, or no order
at all.

Tom Ellison

 

[Guest]

It is vital for me to have the records listed in the same order as they were
imported into the table.

 

[Tom Ellison]

Dear Curious:

Then you need to provide a mechanism, such as an incrementing autonumber, to
preserve this order. Unless you provide an order for the rows in your
table, there won't be any dependable order to them.

Order is strictly by YOUR design.

Tom Ellison