Null Value in Cross-Tab Query

[Cleung]

Is there any way to change the null value in the Cross-Tab Query to show "0". Presently, the null value field is blank. The problem I have is when I set a control in a form to add up the fileds from the cross-tab queries, the formula doesn;t work if the fields are blank. It must have a 0 value in it. My formula is:

[Field a] + [Field b] + [Field c]

Thanks

 

[Jack Cowley]

Search help for the Nz() function....

hth,
Jack

 

[sparx]

try this, the nz function allows us to put a zero where a null value would normally be

nz([Field a],0) + nz([Field b],0) + nz([Field c] ,0)