have you tried
count(isnull([city])) and count(isnull([state]))
Is there not a function to count nulls by column without creating a calculated field for each column? I need to be able to see the level of missingness in my data, but when analyzing larger data sets writing out a calculation such as 'Sum( If isnull([My Column]) Then 1 Else 0 End)' is not very practical...
I am very doubt it. the simplest way is ifnull([your column],1)