Sum Query Based on Null Enteries

[echorley]

In my database, I need to be able to search for a text value, then add the numbers associated with that text value.

For example, if I search for Interceptions, I then want to add up all of the Return Yards associated with those interceptions.

The problem I have is when there are no Interceptions, I of couse get a null value when I try to add all of the Return Yards together.

I am sure NZ is part of this, but after hours of struggling, I cannot get my sum of Return Yards to return a zero value if there were no Interceptions

Any help would be fantastic!

Thanks

 

[echorley]

Got it

Just posting to this forum seems to magically help the answer to appear.

I put the following statement into the Criteria section

Like Nz("Interception","*")

Which changed all the the null values to 0 when I did a summation of the Return Yards.