#error in report from and iff stms

[ViperD]

I am getting a #error in my report from the following code:

=IIf([PPO/HMO]="PPO",[Text84]=Avg(93010)*0.4,[Text84]=Avg(93010)*0.6)

The code is in the control source for a text box on the report. I am trying to set the value of the text box (Text84) to 40% or 60% depending on the value of the PPO/HMO column.

 

[cghoga]

are you inserting this in the control source of [Text84]?

if so, you don't need the [Text84] references.

it would look more like this:

in the Text84 text box, enter this in the control source...

=IIf([PPO/HMO]="PPO",Avg(93010)*0.4,Avg(93010)*0.6)

i'm a little confused about the AVG(93010).
What does this do? What are trying to take the average of?

 

[ViperD]

Thanks for the help, exactly what I was looking for. The 93010 is a column name, I forgot to put it in brackets.