If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Completely Blank Report...no title, data, etc.
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. |
Thread Tools | |
Display Modes | |
|
|