In Access 2007 under MS 10 x64, I run my query sorting two of multiple fields in a table, which gives expected results. However, when I use that query as the record source for a report, the results are not the same. I don't understand why.

I believe I should have asked this question in Computers & Technology>Programming>Databases>Access, but I don't know how to move it. I would appreciate guidance in that move.

A Report has its own sorting. You have to set the sorting in the Report design.