Counting Nulls in Access Query 1

[yenfen]

Hi,
I want to count NULLs in Access Query, I kept getting zero count. can anyone help? The following is the query I'm currently working on:


Select DISTINCT
(Select count(MISSION) from tblSATISFACTION where MISSION IS NULL) as NORESPONSE,
from tblSATISFACTION;

Thank you!!!!!

 

[Norris68]

SELECT COUNT(*) As NoResponse FROM tblSatisfaction WHERE Mission Is Null

 

[yenfen]

Thank you so much Norris!! It works