In my report have a control that works out a ratio for each record compared to the sum of all records for a given field name in a table.
So for example of the field may be 'output' and the control in form calculates the ratio of each individual 'output' as a ratio of the total for 'output'. I also do some other calculations based on this result and then store the result in a control in the form detail called 'Ratios'
I would like to add up all the results for the control 'Ratios' and place the result in an unbound form in the group and report footers. (I can't use a formula as I can't use aggregate functions in and experssion.)
So I'd like to do some VBA that will add each value from the control 'Ratios' and store that in an unbound field in the Group and Report footers called 'Ratio Results'
Can someone help me with code please?
So for example of the field may be 'output' and the control in form calculates the ratio of each individual 'output' as a ratio of the total for 'output'. I also do some other calculations based on this result and then store the result in a control in the form detail called 'Ratios'
I would like to add up all the results for the control 'Ratios' and place the result in an unbound form in the group and report footers. (I can't use a formula as I can't use aggregate functions in and experssion.)
So I'd like to do some VBA that will add each value from the control 'Ratios' and store that in an unbound field in the Group and Report footers called 'Ratio Results'
Can someone help me with code please?
