By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,117 Members | 2,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,117 IT Pros & Developers. It's quick & easy.

Summing a Calculated Avg

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.