I have a report from a query which includes the date of each order. I sort the dates in the report ascending. All is fine until I add a Count in the report footing (just to count the numbers of orders in the report). The Count is correct but the records are no longer sorted correctly by the...