I am using Access 2002. I have created five reports that list totals in the
footer of each for January through December. They are then all on a report
so there is only one report instead of five. They are not linked to each
other.

All of them show up except one. One of the reports shows nothing at all,
not even the title of the report just a huge blank area where the report
should be. I'm assuming this is because there isn't any data pulled when the
query runs. If I run the report by itself I receive rows of #Errors where
all the calculations are but nothing but blank space when it's run with all
the reports combined.

Here is the calculation for January, =Sum(IIf([txtMachineType]="SeCap" And
[txtDRSMonth]="01",[sngQuantity],"0")). I thought I would get the "0" but
didn't. I then added Nz infront of Sum hoping that would work but it didn't.
I still just get a hugh blank space where this report is listed. I need to
show that each month has a zero even if there isn't any data. Any help would
be greatly appreciated. Thanks in advance.