In the footer section for the charges (go to Sorting and Grouping if you don't have a footer), put a textbox with its source like this:
=Sum([charges]) Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of accessrider Sent: Thursday, July 14, 2005 11:04 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Total a field on a subreport to show on the main report I have a subreport (Report3) that has a field called charges. I can sum up the charges in a Text field but I would like for that to show on the Main report. Is there a way to reference it. I have tried [Report]! [Report3]![Text28] but it cannot find the subreport. Thanks! AccessRider Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/