Not understanding output

[David44Coder]

This isn't something I've created but am helping someone with.
I always thought if you opened a query if would display as per its design.
But Dupes in the attached db shows in a different order to the Demo in module 1.
Why is that ? I can't figure it out at all and would like to.

 

[arnelgp]

i think it has to do with the way you Construct the query.
what is the purpose of Distinct Row?
removing it (i already did) will display the same Order as in recordset.

 

[David44Coder]

Thank you. I don't know why DISTINCT is there, but something is weird. It still didn't work for me with DISTINCT gone so I tried yours - and it was ok. Yet the SQL was identical in both. I then deleted and recreated the query - and it came good. Then I put DISTINCT back - and it still works.
Hard to fathom Access sometimes.

 

[Pat Hartman]

I recreated the query and it worked fine. I just opened the query in SQL view, copied the SQL and pasted it into a new query

If someone sorted the original query and saved that, Access is remembering the saved sort. Looks like an undesirable "feature".

I then opened the new query. Changed the sort and saved it. The new query opened to the saved sort rather than the defined sort.