iif Function.

[joeythelips]

Hi,

I have a report which is based on a query.
Alot of the columns are returning nulls. I want to use the iif function to display them as 0 if they are null.
Does anyone have the exact synthax?

Joe

 

[Spellman]

iif(isnull(columnname),0,columnname)

 

[ZanfirMarin]

Nz(ColumnName)