Sorting results in a crosstab

[Joefulmer]

I have a functioning crosstab that displays the right records. In the underlying query the records are displayed in the right format. On the form, which has one level of grouping only, the rows in each group do not seem to honor the sort in the underlying query.

Any ideas?

 

[JoeCruse]

Do you have anything going on, in design view of the report, on the Grouping? Is it telling the report to order itself different from the report?

 

[Joefulmer]

Yes, but it does not seem to conflict...