I have a report that shows several fields, including a field total (currency) and is grouped by quarter, then status, then projectID.  In each footer, there are sums on this currency field, depending on grouping.  I recently had to add a subreport into this report showing changes made to the project, linking the sub by projectID.  This is now causing each sum to add in as many rows as are in the Project_Changes table.

See example pic to show how there is only one projectID, but twolines of change data in the subreport.  The field I'm trying to calculate on shows $42K, but in the group's subtotals, it's showing as $84K because of the two lines of change data in the subreport.

How can I fix this?

I did have the main table referenced in the report, that was the issue.  Thanks!