Summarize a calculated field in a report footer

[Norma]

I have a table with a UPC#, CasesCompleted, TotalHours, standardGoal
(pieces per hour)
I am generating a report that groups by UPC and figures out production
goals. In the Detail section of each UPC, I have a calculated field
that looks like this:
=sum([CasesCompleted])/sum([totalHours])/([standardGoal])
This gives me the percentage of production. Each UPC has a different
standardGoal.

My question is: How can I get an average goal in the Report Footer by
using the amount in the calculated field when each UPC is using a
different standardGoal?

Any thought, ideas, code, or general direction would be greatly
appreciated.

[Larry Linson]

My question is whether the calculated field in the Report Footer would have
any meaning, when each UPC has a different goal? If you can define it, then
someone will likely be able to help you calculate it, but we can't determine
what information would be useful.

It's entirely possible that it might be worse than useless; that is,
misleading.

Larry Linson
Microsoft Access MVP

"Norma" <nj**********@suscom.net> wrote in message
news:20*************************@posting.google.co m...

I have a table with a UPC#, CasesCompleted, TotalHours, standardGoal
(pieces per hour)
I am generating a report that groups by UPC and figures out production
goals. In the Detail section of each UPC, I have a calculated field
that looks like this:
=sum([CasesCompleted])/sum([totalHours])/([standardGoal])
This gives me the percentage of production. Each UPC has a different
standardGoal.

My question is: How can I get an average goal in the Report Footer by
using the amount in the calculated field when each UPC is using a
different standardGoal?

Any thought, ideas, code, or general direction would be greatly
appreciated.

[Norma]

Larry,

The reason for the totaling of the goals for all UPCs is that
depending on the the percent of goal average that the production floor
has reached for the month, quarter or year,we have a program here that
pays out incentives for an average goal of over 105%. I hope that
clears it up a little. The individual UPC goals are a 'weighted' goal.
That is, it totals all the hours ran and all cases ran to determine
the goal%. The same will be for the Report Footer. Any ideas?
questions?

Thanks!

Norma

"Larry Linson" <bo*****@localhost.not> wrote in message news:<C3*********************@nwrddc01.gnilink.net >...

My question is whether the calculated field in the Report Footer would have
any meaning, when each UPC has a different goal? If you can define it, then
someone will likely be able to help you calculate it, but we can't determine
what information would be useful.

It's entirely possible that it might be worse than useless; that is,
misleading.

Larry Linson
Microsoft Access MVP

"Norma" <nj**********@suscom.net> wrote in message
news:20*************************@posting.google.co m...

I have a table with a UPC#, CasesCompleted, TotalHours, standardGoal
(pieces per hour)
I am generating a report that groups by UPC and figures out production
goals. In the Detail section of each UPC, I have a calculated field
that looks like this:
=sum([CasesCompleted])/sum([totalHours])/([standardGoal])
This gives me the percentage of production. Each UPC has a different
standardGoal.

My question is: How can I get an average goal in the Report Footer by
using the amount in the calculated field when each UPC is using a
different standardGoal?

Any thought, ideas, code, or general direction would be greatly
appreciated.