How to display a Summary of Group Items's Count & Sum

[Kinara]

Hi Everyone,

This is my first post here. I'm creating a Group Report which is a Bank Statement like the following..

Deposits & Additions
===============
08/18/2005             Check Received from Customer                  $1000.00  
08/19/2005             Check Received from Customer                  $1000.00  

Checks Paid
=========
08/17/2005             Check paid to Customer                           $1000.00  
08/18/2005             Check paid to Customer                           $1000.00  
08/19/2005             Check paid to Customer                           $1000.00

"Deposits & Additions" and "Check Paid" is a GROUP. I have a text box in the Group Header Section which counts the Items in the Group and another Textbox in the Group Header Section which Sums the amounts in the Group. What I want to do is to display in the Report Header something like the following..

CHECKING ACCOUNT SUMMARY
=======================
                                   Instances                  Amount
Deposits & Additions             2                    $2,0000.00
Checks Paid                        3                    $3,0000.00    
--------------------------------------------------------------------------

What I have done is I have set a 2 Textboxs in the Report Header which are Set to the value of Textboxs in the Group Header which Count and Sum the Items in the Group.
Problem is the Textboxes in the CHECKING ACCOUNT SUMMARY show the first Group's Count and Sum, HOW do I make them show each group's Count and Sum.

Would Appreciate all the Help.

Thanx

Kinara

 

[Kinara]

could someone please take a look at this.

Thank You

 

[ThreeCrow]

Add two more text boxes to you report header same as what you have.

Use the following as the Record Sources

=IIf(([SomeThing])="Deposits",Count([Something]),0))
=IIf(([SomeThing])="Deposits",Sum([Amount]),0))

=IIf(([SomeThing])="Paid",Count([Something]),0))
=IIf(([SomeThing])="Paid",Sum([Amount]),0))

Another way would be to use a subReport