S
SharonInGeorgia
My report has
1. Detail
2. First Group: DIV
3. Second Group: REGION
4. Third Group: STATE
My report includes fields directly from the table but it also includes
complex calculations from a query. Everything works great in the Detail
level, however, I am not getting a percentage on the group levels since these
calculations are weighted. The groupings include "First" in the calculations
when I attempt to recreate the calcs for the group level. How can I get the
weighted percentages for my DIVISION and REGION levels?
Is there a way to use variables so that I can recreate the group
calculations without being tied to the Access report structure?
1. Detail
2. First Group: DIV
3. Second Group: REGION
4. Third Group: STATE
My report includes fields directly from the table but it also includes
complex calculations from a query. Everything works great in the Detail
level, however, I am not getting a percentage on the group levels since these
calculations are weighted. The groupings include "First" in the calculations
when I attempt to recreate the calcs for the group level. How can I get the
weighted percentages for my DIVISION and REGION levels?
Is there a way to use variables so that I can recreate the group
calculations without being tied to the Access report structure?