Are you grouping by the field? If so, you can add a hidden text box in the group header or footer and set the control source to: =1. Set the running sum to Over All and the Name to txtRunSum. Then in the Report Footer section you can add a text box with a control source of: =txtRunSum
Sent: Wednesday, September 28, 2016 9:35 AM
Subject: [MS_AccessPros] counting number of unique entries in a report field
Is it possible to count the number of unique entries in a report field?
Posted by: Duane Hookom <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|