I have a report with 4 sub reports imbedded. Each report has a separate table it reports on with 3 fields and 2 of the fields have sum formulas. Here's my dilema. When there are values in one of the fields with formulas I see all of the fields with 0's if no sums. If a report does not have any values in the sum fields I don't see any of the fields for that report. I even tried using the IIf statement (=IIf([SumOfOrdCash] Is Null,Sum([SumOfOrdCash]),0)) in the control source of the reports but to no avail. Has anybody experienced this before? If so Help!
