Queries :: Unable To Count The Number Of Null Fields

I am trying to create a clean database and code to generate a report.

I am trying to count the number of null fields in one of my queries:

However, because of this expression, I cannot carry other fields with it. So the end result looks like:

But I would really like it to spit out the following information:

Total Not Fixed: 241
Department: Sustaining Eng

is there a way to create an SQL query to simply add data: I have tried the following:

Code:

ALTER TABLE qrySustainingEngNotFixed2 ADD Dept TEXT(25)
Insert Into qrySustainingEngNotFixed2 (Dept) Values (Sustaining Eng)
SELECT TotalNotFixed, Dept
FROM qrySustainingEngNotFixed2;

The above isn't working. Keep in mind that I want this is just for display purposes. I pondered making a custom table and then making a Union Query, but I'm trying to do this all in one SQL statement.