IIF Not Working 1

[jlg5454]

I'm trying to make this IIF function work with no sucess:
NewTot: IIf([StatTotal]="",0,[StatTotal])
It gives me blank for the nulls and #Error for what I want StatTotal value to be.

Thanks,

Joe

 

[PHV]

You may try this:
NewTot: Val([StatTotal] & "")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlg5454]

Thanks I like that. I actually got this to work with this after I posted - NewTot: IIf([StatTotal] Is Not Null,[StatTotal],0)

 

[PHV]

Shorter notation for exactly the same as your latest IIf:
NewTot: Nz([StatTotal],0)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886