Hi,
I have a report for Judges and their cases Numbers, grouped by Judge Name,the detail starts on a new page every time a judge changes. On the Judge footer I am displaying Count of Total no of cases for that judge and Count of Total no of Unique Cases for that Judge.I have a text box for each Count and using DCount display the counts.
Now the same counts for every judge needs to be displayed on the Report Footer as a summary page like,
No of Cases for Judge1 -
No of Unique cases for Judge1 -
No of Cases for Judge2 -
No of Unique cases for Judge2 -
No of Cases for Judge3 -
No of Unique cases for Judge3 -
No of Cases for Judge4 -
No of Unique cases for Judge4 -
Please help,
Thanks