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.