Doing an Average of detail lines group break

techexpressinc

Registered User.
Local time
Today, 06:39
Joined
Nov 26, 2008
Messages
185
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
 

Attachments

  • PropertySheetAvg.JPG
    PropertySheetAvg.JPG
    44.5 KB · Views: 105
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...
 

Users who are viewing this thread

Back
Top Bottom