calculated field from calculated field?

[RedGoneWILD]

I have a report that is grouped by an ID number as a header, then a detail section displaying that relates to the ID number. There are two currency fields, and a calculated field which displays the sum of the two currency fields for each record.



Then I have a footer of the ID number which has a calculated field, which I want to be able to total the calculated field for all records in that group. What's the easiest way to achieve this?

example of report layout:

IDNumber
...............Person........currency1......curren cy2.......totalCurrency
.................................................. ..................sum Of Total Currency


totalCurrency = sum of currency1 & currency2

sum of Total Currency = sum of all total Currency in that group


I have totalCurrency calculated field working...that was easy....it's the sum for the group i'm having trouble with

[pbaldy]

You can't sum the calculated textbox if that's what you're trying to do. Presuming the total is

=Currency1 + Currency2

the sum would be:

=Sum(Currency1 + Currency2)

[RedGoneWILD]

u know what amazes me is that i swear i just did that and it didnt work...must have been something wrong with my syntax but i used the sum() function...unbelievable

then i go and spend 5 minutes making a thread about it, and then looking like an idiot because it works like i thought it would the first time

thanks again...im sure i'll need your help many more times for simple stuff like this

[pbaldy]

No problemo.

[Rawb]

Pbaldy's good at making people feel that way. I know he does it to me all the time.

[pbaldy]

Is this about the "idiot" thing? If so, I resemble that remark!

If I make anybody feel like an idiot, it's probably because I feel like an idiot a lot, and it may be contagious.