getting a count from a calculated field in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in a report that gives an average of an employees adherence
for the month. I'm trying to create another field that gives the percentage
of the employees that meet goal based off that field. Every time I run the
report I get a pop-up screen asking me to enter the Average of Adherence.
Here is my formula

=Sum(IIf([Avg Of Adherence]>91.5,1,0))/[Avg Of Adherence]

Please help
 
Correction to my formula

=Sum(IIf([Avg Of Adherence]>91.5,1,0))/Count([Avg Of Adherence])

Sorry
 
Dmackcwby said:
I have a field in a report that gives an average of an employees adherence
for the month. I'm trying to create another field that gives the percentage
of the employees that meet goal based off that field. Every time I run the
report I get a pop-up screen asking me to enter the Average of Adherence.
Here is my formula

=Sum(IIf([Avg Of Adherence]>91.5,1,0))/[Avg Of Adherence]
Click to expand...


The aggregate functions can only operate on **FIELDS** in
the report's RecordSource table/query. They are not aware
of **CONTROLS** in a form/report.

Change the expression to use the record source field name
instead of [Avg Of Adherence].

Either that or you misspelled the name of the field.
 
Back
Top