Hi - I am having a heck of a time figuring this out.
I have a table called "Days" that holds different tasks with various dates. Some tasks have the same date.
In a separate table called "Crew", I assign the Tasks to the crew, and can rollup the linked records to only return the unique dates. However, when I try to count these, it adds the tasks up on the same date, even though I only need it once.
Example:
DAYS TABLE:
Ben's Birthday - 3/9
Pickup John - 3/9
Brenda's Birthday - 3/10
CREW TABLE:
John - Linked to Ben's Birthday, Pickup John, and Brenda's Birthday Records
Rollup field: Arraying unique dates, only return 3/9 & 3/10 as desired.
However, when trying to count unique dates, it is still counting all the records even if they have the same date. So it returns 3. Help!!
