Replace blank fields with 0

[mahadevan.swamy]

I have some blank spaces in the report. I would like to fill these
blanks with a 0. This is like replacing blank fields with a 0. I have
tried using Null functions and etc... but is not working properly. I
would appreciate if anyone can help me out. Thanks in advance.

Mahadevan Swamy

 

[Jeff Boyce]

From a user standpoint, it isn't clear whether a "blank" field contains a
Null or contains a zero-length string.

But if there really isn't anything in the field, why put a zero (0) there?
In some contexts, zero actually means something...

Regards

Jeff Boyce
Microsoft Office/Access MVP