modify report to bring in a another query item

[nfldbunker]

hi

i have a report created  which shows institution,diagnosis,pat age and the count of each diagnosis.
At the bottom of each grouping i have institution has # of cases, average age and total of diagnosis.
I want to add an extra item in teh summary which would be a case count na dthenshow the average.

I would create another query to count the total cases but how do i put this back into my report?

thanks in advance

bunker 

[MFGF]

Drag in a Singleton from the toolbox - you may need to unlock the structure to drop it into the group footing.

[jahnavi]

You can use the singleston or repeater for this

[nfldbunker]

how do i bring in the total of the data totals prior to the filter being applyied?

[blom0344]

Query associated with singleton,list,repeater or associate it with the page itself..