SQL Null Query

[emueller]

I am working on a query that calculates a the average of the difference between two dates.

The issue I am having is that there are some pieces of occasional data that can severly skew this average, so I don't want to include them. So I would like to have the query ignore data where the field that causes the skew is null.

As a truncated example, I'm using:

IIf([Transferred]=True And [Legal Hold Off]=Null And...

but as soon as I add the Null parameter, my query returns nothing. The proper syntax must be simple, but I'm stumped!!

 

[PHV]

Replace '=Null' with ' Is Null '

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[emueller]

I knew it had to be simple. Thanks!!