IIF Label Assistance

[Listerman]

Basically I have a report pulling individuals average talk times on a phone.

Depending on their time we associate a Rating.

On Report_Open I was trying to set a
IIF ([AvgTT] > "85"), AvgTTlbl.caption = "Exceeded", AvgTTlbl.caption = "Partially Exceeded"

According to the AvgTT properties its a textbox but you can use AvgTT.text or value and I consistently receive:

You entered an expression that has no value.

Any advice? I am new to report generating so if this is a noob question, my apologies.

 

[dsfcom]

Try something like this:

If Me.AvgTT > 85 Then
    Me.AvgTTlbl.Caption = "Exceeded"
Else
    Me.AvgTTlbl.Caption = "Partially Exceeded"
EndIf

Or test the value of AvgTT with this:

Dim AvgTTTest1, AvgTTTest2
AvgTTTest1 = Me.AvgTT
AvgTTTest2 = 1
If AvgTTTest1 > AvgTTTest2 Then
    MsgBox "1 > 2"
ElseIf AvgTTTest1 < AvgTTTest2 Then
    MsgBox "1 < 2"
ElseIf AvgTTTest1 = AvgTTTest2 Then
    MsgBox "1 = 2"
EndIf

Should give you an idea of how the value of AvgTT is being evaluated.