IIF Statement

[Davidsm]

How would i complete this IIF statement if a want to fill the empty fields in a column called REGION_NAME with the word "BLANK" and use whatever is in the populated fields if not blank

IIf([dbo_MIS_IntakeM td]![Region_Name] Is Null,"BLANK","" )

Thanks Dave

[Stwange]

How would i complete this IIF statement if a want to fill the empty fields in a column called REGION_NAME with the word "BLANK" and use whatever is in the populated fields if not blank

IIf([dbo_MIS_IntakeM td]![Region_Name] Is Null,"BLANK","" )

Thanks Dave

If I understood you correctly, this should do it:

IIf([dbo_MIS_IntakeM td]![Region_Name] Is Null,"BLANK",[dbo_MIS_IntakeM td]![Region_Name])

Hope this helps.

[barry07]

But

NZ([dbo_MIS_IntakeMtd]![Region_Name],"BLANK")

is slightly less cumbersome