Count Function (Microsoft Access SQL) [Access 2007 Developer Reference]

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

msdn.microsoft.com