Hi, i am grouping by month and the report does show this grouping as first level. I need the sort okdest to newest as it is now. The problem is that it wont group on CoName as the tecord is an older date. Let me know if that helps.
Ok I see you uploaded a db. On phone now. Will be at computer soon. Thank you
I have looked at the db and its pretty close but I need the first grouping on CoName to be the oldest date but currently is shows CoB as the first grouping and has Jan 29 and Jan 30. So the first record in the rpt should be Jan 24 as its the oldest and then the next grouping would be on P-2 because the coname has the second oldest of Jan 27. I tried to simply add a sort order on [Date] but it messes it up.
Let me know if you follow me.
I noticed that if I put a sort on the [Date] in the query it looks correct when I run the query but the report doesnt display it the same for some reason.
wait..i think I have it now. I put the sort rt below the MonthID on the report and it looks ok now. thank you. I think I am good nnow with your solution. It works. thank you much
Well I added more data and it doesnt seem to group like I thought. I have not used EE in awhile. Since the question is closed, I assume I will have to ask a moderator to re-open. Kindly let me know best steps. Thank you...sorry.
or do I just ask another question? I dont mind doing this.
Anders, i am viewing from my phone and i am not sure if there is something attached? It doesn't appear there is an attachment.
Ahhh. Good news...it looks great! Thank you for the follow up on that one. Much appreciated.