IIF Function

  • Thread starter Thread starter ReportTrouble
  • Start date Start date
R

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
 
ReportTrouble said:
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
Click to expand...


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])
 
Back
Top