I have a report with rows and rows of record lines. In my field [LastNameFirstName], I'd like to write an expression in an unbound text box (for the report header)that would give me a number count of all names in the report, but I need the expression to eliminate the duplicates from the total. Could it be done with just using the name field? If needed, the names do have associated Record ID numbers I could pull into the report - if using a number would be simpler.
If not an expression...maybe some VBA. I'm not sure how to approach this.
Any suggestions would be greatly appreciated. This challenge is beyond my pay grade.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.