IIF Function

[ReportTrouble]

Ok So I am in a Query Trying to count a score.

I Have the following expression:

Score: IIf([Yes/No RFI]="Yes",[Click Count]+10,[Click Count])

Which Works Great... However... If a record has a "Yes" and a Click Count of
"0" the score is blank while it should be "10".... Someone please help

 

[golfinray]

Try IIF([yes/no RFI]="yes",([click count]+10),[click count])

 

[Marshall Barton]

Ok So I am in a Query Trying to count a score.

I Have the following expression:

Score: IIf([Yes/No RFI]="Yes",[Click Count]+10,[Click Count])

Which Works Great... However... If a record has a "Yes" and a Click Count of
"0" the score is blank while it should be "10".... Someone please help

I suspect that the problem is when Click Count is Null, not
when it is zero. If I'm right, then use the Nz function:

Score: IIf([Yes/No RFI]="Yes",Nz([Click Count],0)+10,[Click
Count])