Confused about sums for groups

[accessinformation]

I have a report which has several rows of data. There are three different category groupings. I am trying to sum the data for each category group (over group). Then I will eventually have to get a sum for over all. My problem is every time I have tried to do this by putting a sum text box in the group footer, I get a sum by every row and THEN a sum over group. Can anyone suggest what I may be doing wrong?

Thank you

 

[teqtaq]

Are you trying to insert in data source =SUM([Field])?

 

[dhookom]

You should be able to place a text box in any Report or Group Header or Footer to get sums with a simple expression like:
=Sum([Field to Sum])

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[accessinformation]

thank you. i got it to work finally but now i have to do some research because there is one section that is not summing properly. probably some data error. thanks a lot! i really appreciate it!

 

[dhookom]

one section that is not summing properly" might be a Page Header or Page Footer.

Duane MS Access MVP
Now help me support United Cerebral Palsy