PC Review


Reply
Thread Tools Rate Thread

Average a returned value in a report

 
 
=?Utf-8?B?U2FpbG9yUm95?=
Guest
Posts: n/a
 
      25th May 2007
I have a report that returns a value named Efficiency. It is based on a
query that takes the total parts produced divided by the hours charged and
returns the parts per hour. Then it divides it by the number of parts per
hour estimated and returns an efficiency value in %. This has criteria that
limit the dates in the report. The report returns the count of items and the
efficiency of the different jobs. I want to total the efficiencies in the
report and divide it by the count to get an average efficiency. How do I do
this? I am using Access 2007. Thanks for any help.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Returned Record Count Dermot Microsoft Access Reports 2 4th Dec 2008 11:34 PM
IF/COUNT/AVERAGE... Value returned is incorrect. =?Utf-8?B?UmViZWthaA==?= Microsoft Excel Worksheet Functions 3 28th Sep 2007 04:25 PM
Duplicates returned in report =?Utf-8?B?VGVyaQ==?= Microsoft Access Reports 12 7th Jun 2006 06:41 PM
No Data Returned - Would like that written on the Report =?Utf-8?B?U01hYw==?= Microsoft Access Reports 1 3rd Nov 2004 04:53 PM
Print a report when no data is returned Kate Microsoft Access Reports 4 13th Nov 2003 04:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:23 AM.