Converting zero to Null value

gal · Jun 4, 2004

Hi group,

I have a field that has numbers includig zeroes(0). How
can I covert the zeroes to NUll( blank to be displayed).

Thanks group

Matt · Jun 4, 2004

IIF([Field Name]= 0,Null,[Field Name])