Summing a Calculated Avg

[turtle]

I understand that access can not sum a calculated field but am having
trouble figuring out the work around.
I have a report that averages the cost of each part number. Each part
number will have multiple unit costs that i need to get an avg, min
and max. I would like to sum these avg, min and max at the botttom of
the report.
Part Unit Cost
abc 3
abc 1

Avg 2, min 1, max 3

bdc 4
bdc 2
Avg 3, min 2, max 4
Here is what i want to figure out in the report footer
*********************************
Report Footer
Totals - Avg 5, Min 3 and Max 7

[Gary Floam]

Hello Turtle,

Try having a separate query for to calculate the values you want on the
footer, and then use DLookup there to get these values into the report.

Hope this helps,

Gary

"turtle" <ko****@vistacontrols.comwrote in message
news:11**********************@q66g2000hsg.googlegr oups.com...

>I understand that access can not sum a calculated field but am having
trouble figuring out the work around.
I have a report that averages the cost of each part number. Each part
number will have multiple unit costs that i need to get an avg, min
and max. I would like to sum these avg, min and max at the botttom of
the report.
Part Unit Cost
abc 3
abc 1

Avg 2, min 1, max 3

bdc 4
bdc 2
Avg 3, min 2, max 4
Here is what i want to figure out in the report footer
*********************************
Report Footer
Totals - Avg 5, Min 3 and Max 7