I have a report that uses 3 tables.  1st table is the financial accounts master, 2nd table is the summary financial actual information by by year and period and the 3rd table is the summary financial budget information by by year and period.  I am linking the 1st and 2nd table by 'account index' and the 2nd and third tables by 'account index' and 'period id'.  I am trying to create columns for Month Actual, Month Budget, YTD Actual and YTD Budget.  My problem is that data stored in the 2nd and 3rd tables store the information by period and account.  I am grouping on the account number.  At the detail level I am getting duplicates on amounts by account (i assume because the accounts are duplicated for periods in the 2nd and third tables).  Can anyone suggest how I might remove the duplicates???   I have tried suppressing the duplicates at the field level but am unsure how or if I can suppress the duplicates when I sum at the group level.