Replace blank fields with 0

  • Thread starter Thread starter mahadevan.swamy
  • Start date Start date
M

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
 
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
 
Back
Top