count fields that have null values for one record???

[supernintendo]

hi , i want to be able to create a query that will count all the fields that have null values for one record in a table

please could somebody help me achive this ,


thanks

Matt

 

[Pat Hartman]

Select Count(*) As CountOfNulls
From YourTable
Where SomeField Is Null;