Is there a way to set default values for a numeric field? I have several fields that sometimes are null. I want the nulls to show as zero. I tried iif(value is null, 0.00 , value) but it gives an error on the “null” word. I tried “IsNull”, “IsNothing” and “IsNumeric” all with the same error.

Any ideas?

OK, I figured it out. isnull(field,0) will put in a zero if the field is null.