Sorting issues in report

[Kelly@AllenEnt]

I have a report that I have been using for a long time. For some reason, it is refusing to sort by "Order Date" properly now. I have it checked it marked for "ascending" in the design view. It is sorted in the table and query that creates the report. Yet for some reason, it will not sort properly now. :banghead:

 

[Eljefegeneo]

Just a suggestion, but have you checked the grouping and sorting? I have had this problem before and found that the grouping and sorting at the bottom out rules the sort by right clicking on the field and selecting a different sort.

 

[Kelly@AllenEnt]

That sorted it. Thanks. Why did the original way stop working?

 

[Eljefegeneo]

I wish I knew the answer to that. Had this problem several times and learned to check that first.