Count a Null value in query

[Rick4077]

If this line of a query comes across a null in the field S.SellName I still need the query to count that null value.

,Sum(IIf(S.ListName Like C.OfcName&"*" And S.SellName Not Like C.OfcName&"*",1,0)) AS TSO

Can I use something like this in the WHERE clause?

If IsNull S.ListName OR S.SellName Then Null=""

I'm guessing here.

Thanks . . . Rick

 

[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

 

[Rick4077]

That's exactly what I was doing!

Here is how I fixed it.

,Sum(IIf(S.ListName Like C.OfcName&"*" And NZ(S.SellName) Not Like C.OfcName&"*",1,0)) AS TSO
,Sum(IIf(S.ListName Like C.OfcName&"*" And NZ(S.SellName) Not Like C.OfcName&"*",S.SalePrice,0)) AS TSODV

Thanks Much!

Rick