Recent content by Mike H.

If I get this right, you only want to count the number of records , I do this by going into design mode within the report and make sure "report footer" is visable ( you usually have to extend it down) and insert a test box with the label. The text box will be "unbound" right click on it and go...

Yep, that did it, I had thought that sorting the query wouls have carried over to the report, much appreciated.

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...