getting a count from a calculated field in access

[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

 

[Guest]

Correction to my formula

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

Sorry

 

[Marshall Barton]

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]

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.