Lani,
You can't Avg() or Sum() an expression from one section to another.
The easiest solution would probably be to add the expression to your report's record source by creating a new column that can be displayed and averaged:
TacHrGross: [Field Size]*[Price Per Ac]/[Tac Time]
You could also use a control source like:
=Avg([Field Size]*[Price Per Ac]/[Tac Time] )
Make sure you are not attempting to add the average to a PAGE section.
Duane Hookom MVP
MS Access
----------------------------------------
> From: mahinalanibaker@yahoo.com
>
>
> Okay so my query has Field Size, Price per ac and tac time. I have another column called Tac Hr Gross. So the calculated field is the tac hr gross and the expression for that is: =[Field Size]*[Price Per Ac]/[Tac Time] which works just fine. But at the end of the report I would like an average of all the jobs. How do I do that? I see there is a blue line with a box underneath it so I tried this expression: =Avg([Tac Hr Gross]) But nothing calculates. How do I fix this?
>
> Thanks,
> Lani --- In ms_access_professionals@yahoogroups.com, <duanehookom@...> wrote:
> Lani, You can post the calculation/expression from your report and provide some specifications about your record source fields and requirements. Duane Hookom MVP MS Access ---------------------------------------- From: mahinalanibaker@... I still can&&39;t get it to upload! Anyway does anyone understand what my giberish means enough to help me? Please! Thanks. :) --- In ms_access_professionals@yahoogroups.com , <wrmosca@...>; wrote: Sorrry, Lani, but our group doesn&&39;t allow attachments. Feel free to upload a copy to our Files>Need assistance folder. Bill Mosca --- In ms_access_professionals@yahoogroups.com , <mahinalanibaker@...> wrote: I use Microsoft Access 2007. I created a query/report. I have a calculated field in my report. It works the way I want it too, but at the bottom of it I would like the average of all of them. I have attached a screen shot including my expression so you can see, it&&39;s called Lani&&39;s report. I&&39;m not great at explaining things so I thought this might be better. Thank you.
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar