How to get report to only show <85%

[Nancy via AccessMonster.com]

I have a report that is based on a query. This report takes the information
I've entered and uses a calculation to total an employee's total efficiency
for the job they perform. On this report I am only wanting to see people who
have less than 85% efficiency. How would I get my report to perform this task?
This is the formula in the control source for my Total Efficiency text box:

=(([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std Hours]+[Off Std Hours])*
[Employee Data_Rate])

 

[Steve]

Open your query in design view and put the following expression in the first
blank field:
Efficiency:=(([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std Hours]+[Off
Std Hours])*
[Employee Data_Rate])

Set the criteria of the above field to:
<.85

Open your report in design view and change the control source of your Total
Efficiency text box to Efficiency.

Steve
(e-mail address removed)

 

[Nancy via AccessMonster.com]

Steve,

Thank you for responding. I tried your approach but I seem to be having a
little trouble. I somehow failed to put in the correct calculation in my
first post. I use the Avg function in my code:

=Avg((([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std Hours]+[Off Std
Hours])*[Employee Data_Rate]))

When I put in the code like you have it, the query works fine. However, when
I add Avg to the beginning I get the following error message:

You tried to execute a query that does not include the specified expression
'Employee Data_Rate' as part of an aggregate function.

Is there any way around this problem?

Open your query in design view and put the following expression in the first
blank field:
Efficiency:=(([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std Hours]+[Off
Std Hours])*
[Employee Data_Rate])

Set the criteria of the above field to:
<.85

Open your report in design view and change the control source of your Total
Efficiency text box to Efficiency.

Steve
(e-mail address removed)

I have a report that is based on a query. This report takes the information
I've entered and uses a calculation to total an employee's total

[quoted text clipped - 9 lines]

Hours])*
[Employee Data_Rate])

 

[Steve]

Nancy,

Go back and put the expression (without the Avg) I gave you in the first
post in the empty field. Then change your query to a Totals query by
clicking the Sigma (looks like capital E) button in the menu at the top of
the screen. Then change Group By under this field to Avg.

Steve

Steve,

Thank you for responding. I tried your approach but I seem to be having a
little trouble. I somehow failed to put in the correct calculation in my
first post. I use the Avg function in my code:

=Avg((([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std Hours]+[Off Std
Hours])*[Employee Data_Rate]))

When I put in the code like you have it, the query works fine. However,
when
I add Avg to the beginning I get the following error message:

You tried to execute a query that does not include the specified
expression
'Employee Data_Rate' as part of an aggregate function.

Is there any way around this problem?

Open your query in design view and put the following expression in the
first
blank field:
Efficiency:=(([Quantity]*(Round([Hour Unit],3)))*7.5)/(([On Std
Hours]+[Off
Std Hours])*
[Employee Data_Rate])

Set the criteria of the above field to:
<.85

Open your report in design view and change the control source of your
Total
Efficiency text box to Efficiency.

Steve
(e-mail address removed)

I have a report that is based on a query. This report takes the
information
I've entered and uses a calculation to total an employee's total

[quoted text clipped - 9 lines]

Hours])*
[Employee Data_Rate])