Access 2002 Report
I have a report that has multiple detail lines. I have it so that only the top line is visible (which is what I want) BUT when I go to sum, I am getting the total for all of them.
My report is bit more complex but here is an easier example:
Each product (PrA and PrB) has 3 items. The overall ship charge for PrAis 2.00, yet the detail shows 2.00 for each item, and the overall ship charge for PrB is 3.00, yet the detail shows 3.00 for each item.
When I go to total, I want the total to be 5.00, not 15.00.
PrA Item ShipChge
1 2.00 (visible)
2 2.00 (hidden)
3 2.00 (hidden)
PrB Item ShipChge
1 3.00 (visible)
2 3.00 (hidden)
3 3.00 (hidden)
Can anyone explain to me how to modify the report so I only get the sum of the first line of each item?