unexpected prompts in a report

[Guest]

I have a 2 text fields with IIF statements in the control source that say if
number is > then average, 'yes' (in the first column) and if number< average
'no' in the other column. These fields are not bound to a table or query,
just calculated in the report. The problem is that when I use the
=Count([Field Name 1]) in one of my footers and run the report, a prompt
appears saying 'Field Name 1". How can i get rid of that error.
The same happens for my 'no' column , =Count([Field Name 2)].
So I get 2 prompts!

 

[Allen Browne]

As you found, you cannot sum a text box.

You could repeat the entire expression from the text box in the group
footer's text box, e.g.:
=Sum(IIf(...

Or you could create a query, and enter the calculated field there. Then you
have a field to sum in your footer.