Average Group Headings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If I understand correctly, can't you "sums up the total products" for the
entire report and then divide by Max(DateField) - Min(DateField)?
 
That would only work if I were making products every day. We don't
necessarily make product every day.
 
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
 
Thank You, that works great.

Duane Hookom said:
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
Click to expand...
 
Back
Top