Show totals on Pie Chart

[jazzy]

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:

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")));

[June7]

Set report RecordSource to raw data query and use Sum() function in textbox or an aggregate query that sums the data and bind textbox to that field or use DSum() domain aggregate function in UNBOUND textbox.

[jazzy]

Thank you but NoGo.... set Control Source in unbound text box to: =DSum([Totals],[qry_AssetTotals],[MonthID]="Between [Forms]![frm_NewAssetMain]![From] And [Forms]![frm_NewAssetMain]![To]")

[jazzy]

Got it, thank you

=DSum("[Totals]","qry_AssetTotals","[MonthID] Between [Forms]![frm_NewAssetMain]![From] And [Forms]![frm_NewAssetMain]![To]")