Report sorting and filtering (1 Viewer)

How does a Report sort it's data in the absence of any report sorting (seeing as it disregards the underlying Query) ?

It doesn't.

If I shuffle a deck of cards and then lay them face up on the table, your mind will see patterns in how they appear. That doesn't mean my shuffling applied any order to them. The fact of the matter is they have to appear on the table some how and your mind makes the leap to the fact that an order was applied to them.

There is no sorting in a report (or query or table) that you have not explicitly told how to be sorted.

Bugger !!!
The thing that throws you is that it is consistently sorted in the same (as you confirm) way.

That's like shuffling your cards and getting the same random result everytime

Thanks Plog

ECEK,

If you shuffle a deck, turn the cards over, and place them in a new stack face up, if you turn the deck over without shuffling again you get the cards in the same order again.

If you DON'T tell the query/table to shuffle things you should see them in the same order until something changes, such as compact/repair on the database or new records overwriting "Deleted" records.