Just come to realise that I've never used form vars before - and the reason why - they're so confusing
So after much struggling and swearing I've managed that. Thanks Naomi and Sergey. Sergey, for once you were pipped at the post. :-)
>It's other way around. You create the report variables that do the same calcualtions as fields in the group footer now and reference them in the group footer and your calculations.
>
>>Thank you, bless you but what do I put in the var's? Sure they need to refer to the group total field but how do I refer to a field that hasn't a name but is the sum() of a group column.
>>
>>>You would use report variables instead.
>>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.