Counting records

Hi everyone, I need some help on the following scenario… thanks in advance.


Based on the relationship of the collections above, I need to count the number of offices a user has visited within inclusive dates. For example…

user visits 10 offices over a period of 1 year.
user visits the some offices more than 1 time in same year.
I want to count the number of offices the user visited for that year but only count an office 1 time even if the user visited that office multiple times.
So at a max count if the user visited all the offices multiple times, I only count a max of 10 offices.

Any tips and/or techniques are greatly appreciated.


This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.