Count detail only if it's different than other details in a group

[Tammy]

Hello,

I am creating a report that keeps track of training sessions per application
(for ex. the application is "Access", and the training session is called
"Creating Reports").

I am grouping the report by application name, and in the details of each
group I am displaying the name of the training sessions and dates those
sessions ran. In the group footer I have created a textbox that has a formula
displaying text that says "Total number of training sessions for [application
name]:" - this will act as a label for another textbox that should display
the number of training sessions for that group's application.

The problem is that I want all training sessions listed and the dates they
ran, however, some training sessions will be run more than once. I'd like the
count in the group footer to only count the unique names of the training
sessions, not every time it ran.

Any chance of this happening? Again, I'd like all occurrences of training
sessions listed, but only the unique names counted in each group. Also, more
than one session can run on the same day, so I can't group further by date.

My fieldnames are as follows:
strApplicationName
strTrainingSessionName
dtmTrainingSessionDate

Thanks for any suggestions!