Programming Totals by group in a report.

[MatthewGrace]

I have a report listing Products, grouped by color, with a Total Weight field for all the products which belong to the said color group. Everything is working fine, but I decided to start using vba to pull values from the Totals field and do very fundamental math. In the photo below you can clearly see my dilemma:

The very last color Group (in this case, it's Biscuit), everything goes swimmingly: the total weight is multiplied by 10. However, each other color group inherits the final color groups "Total weight X 10". here is the Code that makes this happen:


I'm doing much more advanced code at the form level, but this is my very first day playing with Reports, so I'm a bit confused. Any help much appreciated. Matt

[June7]

Can't use the load event for this. Load event runs only once therefore the same value will show for all records.

Why use VBA? This is unnecessary complication and can make reports slower. Put the calc in textbox.

[MatthewGrace]

My ignorance knows no bounds. I have written hundreds of lines of vba for my project, but this is the first time I've used the expression builder. It worked! thank you June.