Sum 4 Fields on a Report 1

[pclutts]

I have a report I'm stumped on. The Record Source for the report is a query called qryDBESummaryRpt. This query is made from two tables: tblDBE and tblProjects. For this query, these two tables are related via a field called ProjectID, which appears in each table but originates from tblProjects. The following fields are in the query: CSJNumber, DBEName, GoalWaiverAmt, GoalShortfallAmt, DBEComitAmt, DBECredit, and Totals. CSJNumber comes from tblProjects, the next four come from tblDBE, and Totals is a calculated field in the query which sums the previous four.

The report I created groups records under the field called CSJNumber. Under the CSJNumber grouping, the report lists the following fields from left to right across the page: DBEName, GoalWaiverAmt, GoalShortfallAmt, DBEComitAmt, DBECredit, and Totals. I am stumped on how to sum these four fields vertically for all the DBEName records under a CSJNumber. I can email a sample database if anyone needs it. Can anyone help? Thanks in advance.

 

[PaulBricker]

You will need a group footer to sum the values you want. On the menu bar go to View...Sorting and Grouping. Your CSJNumber should be in the Fields/Expression list. If it is, go to the Group Properties and find the Group Footer. Set it to Yes. Then in the Group Footer, add a textbox and in the Control Source put
=Sum([GoalWaiverAmt])

or whatever field you want to see sums for. That should do it.

Paul

 

[pclutts]

Thanks a bunch Paul for the help. Your advise was exactly right. I guess I couldn't see the forest for the trees.