The Count function does not count records that have Null fields unless expr is the asterisk (*) wildcard ...
msdn.microsoft.com