Hello
I need to count as one only any Duplicates fields in my report.
I managed to do it in Job No row using the below procedure but fail in both received and completed date.
"To count the number of distinct instances of a Job No in the period covered by the report include a hidden text box, txtIDCounter say, in the group header or footer of the Job No group, with a ControlSource property of =1, and a RunningSum property of Over All. Then in the report footer, not the group footer, I include a visible text box whose ControlSource property references the hidden text box with =[txtIDCounter ]."
Please, I appreciate very much any kind of help to meet my expected result of 2 and 3 as indicated in the attached pic.
Thanks in advance
Joey
I need to count as one only any Duplicates fields in my report.
I managed to do it in Job No row using the below procedure but fail in both received and completed date.
"To count the number of distinct instances of a Job No in the period covered by the report include a hidden text box, txtIDCounter say, in the group header or footer of the Job No group, with a ControlSource property of =1, and a RunningSum property of Over All. Then in the report footer, not the group footer, I include a visible text box whose ControlSource property references the hidden text box with =[txtIDCounter ]."
Please, I appreciate very much any kind of help to meet my expected result of 2 and 3 as indicated in the attached pic.
Thanks in advance
Joey