[AccessD] Report formatting - SOLVED

Finally solved it - had to put code into RETREAT portion of VB to make
groupfooter invisible for only the last group.    I originally had it in
the format portion but it would eliminate it from all groupings - didn't
make sense -- BUT it is done.  

Have a good weekend

**************************************************
* 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. 


-----Original Message-----

> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> O'Connor, Patricia (OTDA)
> Sent: Friday, January 27, 2006 12:07 PM
> To: Access Developers discussion and problem solving
> Subject: [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?
>