G
Guest
I have a table called dbo_Feature and column called FeatureDateClosed.
I want to get a count of any records where the FeatureDateClosed column is
null. I tried a simple count(FeatureDateClosed) query, with no luck. See
below:
SELECT Count(dbo_Feature.FeatureDateClosed) AS Expr1
FROM dbo_Feature
WHERE ((dbo_Feature.FeatureDateClosed) Is Null);
This gives me zero. It should be about 1100. I vaguely recall that count
isn't for null values, but don't remember the work around. Any help?
I want to get a count of any records where the FeatureDateClosed column is
null. I tried a simple count(FeatureDateClosed) query, with no luck. See
below:
SELECT Count(dbo_Feature.FeatureDateClosed) AS Expr1
FROM dbo_Feature
WHERE ((dbo_Feature.FeatureDateClosed) Is Null);
This gives me zero. It should be about 1100. I vaguely recall that count
isn't for null values, but don't remember the work around. Any help?