Nz or Null

[pommeke]

Hello,

I have a database with count query's.
Then i have a query that gives me a total of the count's
When one of the counts is null the total is also null.
I have tryed to put Nz before de sum, but it is the same.
This is what I tryed:
TotDH: Nz([TotMaHD];0)+Nz([TotVrHD];0)

Can somebody help me.

 

[FoxProProgrammer]

You need to figure out why the count is null. Is it because one of fields is null, or because one of the Join conditions is causing the count to be null? Please post the Query. Instead of using the Nz function on the total, you might try using it on the individual fields that could return a null result.

dz