How to add summary fields to Group Footer in Access Reports? in Access Database Reports    |   |  Help   Search For:     In:   Office   Access Database     Access Database General Questions     Access Database New users     Access Database design     Access Database Forms     Access Database Forms Coding     Access Database Import/Export Data     Access Database Install and Configure     Access Database Macros     Access Database Programming     Access Database Queries     Access Database Reports     Access Database Security              Pat Dools 5/30/2007 7:39 PM PST   Question   How do you add a Summary fields to Group Footers in Access? I have a Detail field I want to Sum in the Group Footer in my report. -- Pat Dools     Was this post helpful to you?         Reply |   Top           Duane Hookom  5/30/2007 9:30 PM PST   Answer   You add a text box with a control source like: =Sum([Your Numeric Field Name]) -- Duane Hookom Microsoft Access MVP "Pat Dools" wrote: > How do you add a Summary fields to Group Footers in Access? I have a Detail > field I want to Sum in the Group Footer in my report. > -- > Pat Dools     Was this post helpful to you?         Reply |   Top           Pat Dools 6/2/2007 10:20 AM PST   Thanks, Duane! -- Pat Dools "Duane Hookom" wrote: > You add a text box with a control source like: > =Sum([Your Numeric Field Name]) > -- > Duane Hookom > Microsoft Access MVP > > > "Pat Dools" wrote: > > > How do you add a Summary fields to Group Footers in Access? I have a Detail > > field I want to Sum in the Group Footer in my report. > > -- > > Pat Dools     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies