Before I start please look at the attachment specially appendix 1 and 2

I'm try to total up some columns in a report but not getting much luck. I want to be able to have a formula on the report that counts up all the sub categories of a column. I have a formula that counts up main column which is :

=Count("[Reason for call1]","Qry_2")

'Reason for call1' is the main category and 'Qry_2' is the Query the report is linked to. See attachment appendix 2.

I want to be able to have a formula on the report that counts the sub category's for example, the total number of 'Auth' in the 'Reason for Call1' column.

Is this something you want performed based on a per page, or based on the report as a whole?

If based on the whole report, why not just write a query that gathers your counts, and put a sub report (based off that new query) in your main report with the totals you seek?