Counting Unduplicate in Fiscal Year

[srctr]

I have a report that counts the number of activities people participate in.
The report counts each activity for the dates entered. We are looking for
duplicate numbers for total times everyone has come in for the activity.
Also looking for an unduplicate number that shows number of people in that
month or that fiscal year for that acticity.

In Detail area of report
1st Field Social is SumOfSocial
2nd Field UCSocial is =IIf([SumOfSocial]<0,1,0)
There is a text box (text13) with an Over All Running Sum =1

In Report Footer
3rd Field is =-Sum([SumOfSocial]) - used to show duplicates
4th Field is =[UCSocial] - used to show unduplicates
Text box with control source = [text13]

There area a total of 25 activities we are counting and each has all four of
these. This report is a subreport of another report. I have two subreports
that grab this information from 2 tables into one report.

In the main report I have in the Report Footer
1st field is
=([MemberUndupSub].[Report]![TSocial]+[GroupUndupSub].[Report]![TSocial])
2nd field is
=([MemberUndupSub].[Report]![TSocialUn]+[GroupUndupSub].[Report]![TSocialUn])
These add the fields from the two sub reports.

My problem is that I need the Unduplicate fields to actually look between
7/1/?? to 6/30/??. These reports only give me unduplicates for the month I
have entered.

I have had to create a separate report for each activity to run that gives
me a true unduplicate number for the fiscal year. Can I somehow get this
feature to run in my main report?

Thanks for the help

 

[srctr]

Can't believe there is no one there that can help with this.