I have a report based on a crosstab query. Three fields are three fields in the query, and several records for each field.

Division (there are 5), Estimated $ and Actual $.
Capitol 23,000 2,000
Capitol 500 500
Central 1,000 500
Central 750 250
etc etc etc

On the report, I want only one instance of each division to show up with a total estimated and total actual $ for each one.

Capitol 23,500 2,500
Central 1,750 750
etc etc etc

I can't seem to make it work. My report only returns the first instance for each division, and not a total for each division. Can anyone help? Thanks in advance.

P.S. - I tried changing my crosstab query, but couldn't get that to work either.

In Access Help, look up grouping records in reports,

Thanks! I figured it out. Had to put my summary fields in the Group Footer to make it add correctly.

The problem is in the crosstab query. If you post it, someone will tell you how to fix it.