Hello All, When you use the Avg() function in a report to average a set of values, the function uses records that contain zero values in the calculation. However I do want "0" 's to show up on reports if the Totals are "0". (I used the nz fuction) For the report footer, the DAvg function does not works too! I am calculating a Total of 20 different controls and the TotalAverage is an unbound control.
Any ideas?
Very much appriciated!!
Any ideas?
Very much appriciated!!