Summing fields in a group

[hlkelly]

I am trying to total a group of fields in a report.

I have a grouping called "Show Expenses" and I want a sum of each field within the group: "show cost", "electrical", etc.

I'm looking for the sum of the show cost plus the electrical for an overall show expense.

any help appreciated.

thanks.

heather

 

[dhookom]

What are your fields? Do you have separate fields for Show Cost and Electrical or are these values in a single field? Normally summing a numeric value is as simple as a control source like:
=Sum([NumericField])

Duane
Hook'D on Access
MS Access MVP