Convert Null to Zero

[saross]

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?

 

[Ukraine82]

If you're running your report from a query make an expression field...

Nz([fieldname],0)

Don't use the equal sign.

hth,
Michael

 

[saross]

I tried that but it returns an error message:

Syntax error (comma) in query expression '[Nz([Q1CapAlloc]),0]'

Any idea why that might be?

 

[dopedealer]

'[Nz([Q1CapAlloc]),0]'

'[Nz([Q1CapAlloc],0)]'

hi again

 

[Pat Hartman]

Get rid of the extra square brackets.