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

[Guest]

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.

 

[Joseph Meehan]

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.

How about showing us the table(s) design?

 

[Guest]

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.

 

[Joseph Meehan]

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.

I was hoping someone with more experience in counting that I have would
stop in and offer you an answer. I have only had to count things a few times
and I used a report or once a query and counted using VBA. The problem is
it has been a while ago and it was not counting across fields only counting
instances in a given field.

Sorry I could not be any any real help.