Consolidating duplicate information

[mgonzales]

I have a report that has groups and sorts.
It sorts by course then by organization. This grouping also contains cost information, priority, and total # of participants. When an organization places the course twice I need my report to rollup that information into one line item and just add up the total cost, and # of participants. How would I do this?

Thanks

 

[vbaInet]

All that's needed is to create a totals query based on the record source of your report (which I would imagine is a query). When you right-click in the criteria section you will see this Σ Totals, click on it. Under Cost you select Sum and under #Participants select Count in the Total row. Use this query as the record source of your report.

 

[mgonzales]

I tried it but it didn't work. Is there a formula that I can place in my report that would consolidate the duplicates and still show a total? I am not using a query to get totals, I have placed formulas in the report to get the totals that I currently have.
Right now it shows like this in my report:
Environment Priority 2 3 $300
Environment Priority 2 1 $100
Environment Priority 3 6 $600

I want it to show:
Environment Priority 2 4 $400
Environment Priority 3 6 $600