Hi, I'm trying to convert Null values from a query upon which my report is based into '0'. I noted on this forum a posting that suggested I go into the query and field properties and put 0;0;0;0 in Format to force the input to be 0 for neg, pos, 0, or null values... but this hasn't worked.
I also tried the =Nz([fieldname],0) and it came up with an error message.
How do I make sure that the fields that aren't returning any value appear as 0? (Or more precisely, £0!!)
Any ideas?
I also tried the =Nz([fieldname],0) and it came up with an error message.
How do I make sure that the fields that aren't returning any value appear as 0? (Or more precisely, £0!!)
Any ideas?