I have a report grouped first by [Date] then by [CoName].
The report groups on date as I want but I need to include all other [CoName] with older dates BUT ONLY within that month.
Currently, those [CoName] records are bumped further down in the same month because of the sort I have.
Co A with all dates in January need to be grouped together in January and sort needs to be by Date oldest to newest.
I hope that makes sense. If not please let me know.
I have attached a pared down db and there is only 1 rpt and 1 tbl