created a report with a pie chart on it. on the report i need to include the total of $14,274,490.71. attached is the report as well PieChart.pdf. i cannot find on how to do this. any help will be appreciated.
here is the query used to generate the data:
Code:
SELECT tbl_NewAsset.MonthID, Sum([tbl_NewAsset]![FeeBasedAssetTotals]+[tbl_NewAsset]![VA]+[tbl_NewAsset]![MutFundAlt]+[tbl_NewAsset]![InvestBrok]+[tbl_NewAsset]![AnnuityFixDefImm]) AS Totals, IIf([Source]="Existing" Or [Source]="Spouse Existing","Existing",IIf([Source]="Child Existing" Or [Source]="Child New","Child",IIf([Source]="Existing Client Referral" Or [Source]="Cold New Prospects","New"))) AS SourceTotalFROM tbl_NewAsset
GROUP BY tbl_NewAsset.MonthID, IIf([Source]="Existing" Or [Source]="Spouse Existing","Existing",IIf([Source]="Child Existing" Or [Source]="Child New","Child",IIf([Source]="Existing Client Referral" Or [Source]="Cold New Prospects","New")));