Total Query(One field with Null value)

[vidplaylist]

My query is not giving total for those rows in which one field has null value. Can you guide me how to get total despite the fact that one field has null value?



Thanks in advance,

[pbaldy]

You can wrap the field in the Nz() function.