Running Total Fields Problem 1

[Pookeye]

I have been trying to sum up something that is in groups.

soo here is the problem, when i use Running total fields and create a sum of some time logged in for example, it just spits out the first field of the sum. instead of the final field of the sum..

example..

via groups, by ID.

ID= CS-101
Total Sum = 900


the above is in group headers.

now when i put that same field into the detailed section it shows this

900
1800
2300
2800
...........
38,280

The last field is what i really want to see in the group heading, so i am not sure why it does not display the sum of it all.... it only displays that first field "900"


I was wondering if I am doing something wrong??



thanks

 

[Pookeye]

well, i figured out my problem, if you want that last field to display (particularly the sum of all the fields in the group, gotta use the group footer to display the final sum.


yeeesh i knew it was easy.. i just didnt know how it worked..

 

[lbass]

Instead of using running totals, if you are able to right click on the detail fields and insert a summary that is accurate (because there is no row inflation), then you will be able to drag the result from the group footer into the group header and display your result there.

-LB