If you want to post a file, you need to upload it at http://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/2_AssistanceNeeded.
You can typically either add the calculation in your report's record source query and then average it in a report or group footer section OR you can Avg(...Your Expression Here...)
Duane Hookom MVP
MS Access
----------------------------------------
> From: mahinalanibaker@yahoo.com
> Date: Thu, 29 Aug 2013 13:52:14 -0700
> Subject: [MS_AccessPros] How do I get a calculated fieds to average in a report.
>
> 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 (2) |
Tidak ada komentar:
Posting Komentar