Using Sum in Report of Access 97

Dear All Expert;
  I have a problem to ask you...Now I am developing application about Tax.
It is Tax from every product and many group of product.
Example :
Can I design Report to find Average of Tax of each group of product ?
Structure :
Group A Have product 1,2,3,4
Group B Have Product 5,6,7,8

Beside Tax from each product , Can I find average Tax from Tax of each product
group ?
=====================================
When I do myself., I create Tax of each product group as Calculated Field in
Product Group Footer. But I can not take Tax of each product group from Product
Group Footer to find Average Tax of all group..( Average Tax of GroupA and
GroupB )

Please answer me...

Thank in advance
u3520384Asked:
Who is Participating?
 
DedushkaConnect With a Mentor Commented:
Hi, u3520384!

>I create Tax of each product group as Calculated Field in
Product Group Footer

Assume in your report based on table Product(ProductId, ProductName, ProductGroup, Tax) you have calculated field txtAvgForEachGroup and its ControlSource = Avg([Tax]).

Resolution.
-----------
1. Place on Product Group Footer invisible text box txtAutoNo, set its ControlSource "=1" and Running Sum to "Over All".
2. Place on Product Group Footer invisible text box txtRunningAvg, set its ControlSource "=[txtAvgForEachGroup] and Running Sum to "Over All".
3. Place on Report Footer text box txtAvgForAllGroups and set its ControlSource to "=[txtRunningAvg]/[txtAutoNo].

Cheers.
Dedushka
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.