how can I count columns that are null by department in an access 2

T

Tasso

Help! my boss thinks I'm an access guru. I have sat here for 8 hours trying
to figure out how I can count the total number of null fields in a column. I
have 4 columns that I need to count the null fields group by department. Any
help would be greatly appreciated.
 
T

Tasso

I guess that would help. sorry.
I have a table called "boxes" with over 1 million rows of data.
I am trying to create a report that will show me a single instance of each
Department Name with a count of 4 columns that each contain null records.
I am trying to count the total number of null fields in the "Contents"
column grouped by Department Name.
In the "To Date" column grouped by Department Name.
In the "Records" column grouped by Department Name.
And last the "Department ID" column.
 
Top