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

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...