how to sum total number of responses

[mdnikki]

I am creating a report that will show all the appeals of our annual mailing and the response rate to each appeal.



The only sum function I am having problems with is getting a sum of total number solicited / total number of responses in a percentage rate.

I am able to get a percentage for each appeal but in my summary at the end of the report I am not sure how to get the sum of the total number for all the appeals.

In the report footer I do sum the total solicited and total responded. But how can I sum on a sum. Does that makes sense.

Basically I would need =sum([Amount Solicited]/sum([Amount Responded])

But can you sum on a sum?

Sorry to be so confusing.

Any help is appreciated.

[June7]

Cannot use aggregate functions on calculated textboxes, only on fields from the RecordSource.

Assume two textboxes in footer named tbxTotalSol and tbxTotalRes. Why not:
=[tbxTotalSol] / [tbxTotalRes]

[mdnikki]

I am a bit confused, I apologize. My text boxes in my footer are aggregate functions summing the columns so if I can't use those I am confused as to what you mean.

Nicol

[June7]

The formula I show does not use aggregate functions. It uses the results of aggregate functions used in other textboxes.