Count unique records in detail section of report
Posted on 2015-02-02
I've tried various queries to resolve this issue but so far no luck. So I want to try a new approach.
I have a report that has a grouping. In the group is a detail section that has a field named POn. Also in the detail section of a field named POnCount. I don't know if the VBA code I'm looking for is in the onprint or onformat event of the detail section but every time a new POn is found, increment the POnCount by 1. If the POn was already cycled through then don't increment by 1.
The after the group has printed set the POnCOunt over at 0.
How can this be done?