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'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'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's called Lani's report. I'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 (6) |
Tidak ada komentar:
Posting Komentar