I realize this question has been asked several times over here, but I can't quite wrap my head around how to take one of the existing solutions and apply it to my situation. Sorry for the duplication.
I have 2 tables with a parent child relationship, 1 parent to many child entries.
Running a summary report from the child table to summarize various fields in the child table entries for a date range.
The date of the child table entries resides within the child table entries
In a child table entry, we make a reference to a parent table entry. We'll call that field Related Parent Entry.
The problem I'm having is trying to get a unique count of Related Parent Entries into my summary report from the child table. The summary report can easily count how many entries have a Related Parent Entry value, but they're not unique.
I've also tried simply adding a category for the Related Parent Entry, but what the user really wants is a column with this count of unique values, not the actual values or an extra sorting/category of these values.
Any suggestion for getting a count of unique Related Parent Entry values into the child table report? Thank you.