Thanks for a great forum!
I have a report which has a Data source PerformanceIndicators.
And I am using a DCount statement to pull information from another query EnCasesAll.
This is done in the Report DcPerformanceIndicatorsMonthlySummary
The queries run from the same between dates inputted on the form MainScreen. Between [Forms]![MainScreen].[txtStartDate] And [Forms]![MainScreen].[txtEndDate]
I have a Report Header with the breakdown for all data between dates.
I have another Header based on the Validation Date sorted by Month
The problem comes in when I use the DCount within the month header, the numbers are exactly the same as the Report Header for The Enforcements Section.
How do I split the DCount statement amongst the months??
Thanks for all your forthcoming help