[AccessD] Report formatting - figured out sum

Ok I figured out my SUM portion of the problem - still need help with
printing problem
Thanks
Patti
**************************************************
* 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. 


_____________________________________________ 

> From: 	O'Connor, Patricia (OTDA)  
> Sent:	Friday, January 27, 2006 11:56 AM
> To:	'Access Developers discussion and problem solving'
> Subject:	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!!!
> 
>  << OLE Object: Picture (Metafile) >> 
>