Query returns null problem 2

[NFLDUser]

I have the following in my query...

CCur(Avg(paid)) + CCur(Avg(provided)) AS avgvalue

Sometimes paid or provided is null so it kills my avgvalue. Is there a way to wrap it to make it a 0 when its null?

 

[PHV]

Have a look at the Nz function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Golom]

CCur([COLOR=red]NZ([/color]Avg(paid)[COLOR=red])[/color]) + 
CCur([COLOR=red]NZ([/color]Avg(provided)[COLOR=red])[/color]) AS avgvalue

 

[NFLDUser]

Thanks guys!!