Need Help With Expression

[Mr Pappa Georgio]

I have a product form that has an inventory transaction subform. I want to develop a way to average the cost of each transaction, and have that average result appear on the product form.

The inventory subform has a cost box. Each time there is a transaction or lets say a price change I want the new price to be averaged together with past cost to give me one figure.

 

[MikeAngelastro]

Try using an aggragate function (Ave) in the footer of the subform and put a text box on the parent form that equals it. Say subform is frmITrans and the text box with the average is txtAve.
On the main form the text box to show that average would equal frmTrans!txtAve.

 

[ggovensky]

Zero Values ARGG

Exclude Zero Values When You Calculate Averages
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!!