[AccessD] Access 2007 Report ?Sort Puzzler?

All,

I have a small test application that is yielding strange results that I cannot figure out.

There is only one table and one query.

The query is sorted on a field called “Customer Name”.

This works fine.

There are two reports.  The original report keeps showing the data in order by “Sales Order Number”.

When I go into Design View for this report, I cannot see any “Group” or “Sort” for this report.

Just for fun, I used the Report Wizard to set up a second report (also with no sorts).  This second report returns the data correctly.  (in the same order as the underlying query).

I must be missing something.  I have run many tests and cannot see what is causing this problem. 

Has anyone else seen this happen?

Thanks,
Brad