[AccessD] Report formatting

Hi all

I have a report with two groupings 
   Main grouping is RPT_GRP_TYPE which has 4 types.  Type 1-3 will
contain records that have a Case information and currency amount.  The
last group is just going to contain the Case information since these
cases did not get payments. 

   The second grouping is by CASE and I want to sum the currency amount
for each case.  It works fine. How do I get the Case footer to not try
and print the sum for the Last MAIN group since there is no payments?

Another question - how do I get the total amount paid to only sum the
amount for each case
I am having a bit of a brain cramp - been working on Sql portion for a
day.

Thanks!!!
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at otda.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.