I'm currently working on a report that has 4 subreports (freshman report query subreport, sophmore report query subreport, junior report query subreport, senior report query subreport) attached to it that each has a value "hours completed" which is added up in a total box in each subreport.
Under the subreports i have a "total" section which has boxes that take the values in the total boxes from freshman, sophmore, junior, senior subreports and places them in this section using the formula "=[Freshman Report Query subreport].Report.[total box]" which is changed per subreport.
My problem is adding nulls (preferibly if box has no value= 0) to these statements but when a subreport isn't present (i.e. someone hasn't completed hours for that year) I recieve error messages.
This is the general layout of what I'm trying to say:
As the link mentions, you'd want that function in a global (standard) module. If you don't already have one, in the VBA editor Insert/Module. Name the module anything BUT nnz, as you can't have a function and module with the same name.