Property Sheet Average Function How to do?

[techexpressinc]

I have a set of details with percents and want a total with an average of the percents. I would think you can have an average with a group break using the average function.

I cannot get it to work. Attached is a screen print. It is probably as usually a minor syntax error in the formatting.



Any help would be Great.

Thx Russ

[techexpressinc]

I have it figured out. The number was coming in as a Percentage. I changed it to a decmial an formatted it as a percent then it worked! Access could Not average percents too complicated...

[RuralGuy]

So this thread is ready for the Solved thread tool right?