Stephen Baez, I believe this is what you are looking for:
SELECT COUNT(*) AS TotalRows, COUNT(id) AS NonNULLRows, COUNT(*) - COUNT(id) AS NULLRows FROM
Modify to fit your database.
COUNT(*) does exactly that, it returns ALL ROWS of a table.
-SQL NEWB