467,166 Members | 1,093 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,166 developers. It's quick & easy.

Summing a Calculated Avg

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

Jun 15 '07 #1
  • viewed: 1391
Share:
1 Reply
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

Jun 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Yaroslav Bulatov | last post: by
7 posts views Thread by Hank | last post: by
13 posts views Thread by Don Sealer | last post: by
1 post views Thread by kevcar40 | last post: by
reply views Thread by King | last post: by
reply views Thread by oyk | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.