Hello everybody, I have quite a problem: This is my data: circuit A:856 1010 7665 circuit B:1100 1191 3284 circuit C:958 1154 4011 ----------------------------------- Total: 526656 597841 287450415 As you can see my sums aren't working. I know why but I don't know how to do it. The first three lines aren't some variables but are each a different field: $F{COUNT(DISTINCTGICR.OBJECTID)}, $F{COUNT(DISTINCTGICPT.SID_PT)} and $F{COUNT(DISTINCTGICPRO.IID_PRO)}. The reason I didn't make variables is simple, in my query I have X lines of these results because for each circuit that I have, I have X troncons (that i need for something else). And my totals are variables where I put the same fields (see above) in sums. Do anybody have an idea of a resolution to my problem? Thank you very much.