OK. I'll try to explain. Here is the data.
Field1 Good GoodVal
000000 001 12
000000 001 10
000000 001 23
000000 001 12
000000 001 10
000000 001 23
....
000001 001 12
000001 001 12
000001 002 13
000001 002 13
000001 002 13
000001 002 13
000001 003 13
000001 003 13
In The Group footer (Good) I add the Field GoodVal open Properties of that field click on Calculations and select Sum.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
