Average Group Headings

[JoeJ]

I would like to average group headings. My detail is a production list of my
proudcts. I have Daily Product Heading which sums up the total products
produced in a day. I would like to have a report footer or some other means
to show the average daily product quantity.

 

[Duane Hookom]

If I understand correctly, can't you "sums up the total products" for the
entire report and then divide by Max(DateField) - Min(DateField)?

 

[JoeJ]

That would only work if I were making products every day. We don't
necessarily make product every day.

 

[Duane Hookom]

You can count the number of groups in a report by adding a text box in the
group header
Name: txtCountGroup
Control Source: =1
Running Sum: Over All

Then you can reference txtCountGroup like:
"sums up the total products"/txtCountGroup

 

[JoeJ]

Thank You, that works great.

You can count the number of groups in a report by adding a text box in the
group header
Name: txtCountGroup
Control Source: =1
Running Sum: Over All

Then you can reference txtCountGroup like:
"sums up the total products"/txtCountGroup