Subreport blank, calculating and page breaks

[jcright]

Hello all,

I have two issues that I need to solve through.

1. I have a report that uses 3 subreports. Each subreport has a total in its report footer. I have a textbox in my main report that adds up all of the totals from each subreport and it appears to display correctly when I select print preview. This only works if all of the subreports aren't blank (I have verified this to be true). 2 of the subreports should always have something in it. The 3rd subreport may or may not have a total because there may or may not be any activity that month for a particular person that the report is being conjured up for.

My equation in the text box for the mainreport is: =[subreport1].[Report].[subTotal1]+[subreport2].[Report].[subTotal2]+[subreport3].[Report].[subTotal3]

I've tried wrapping the subreport total in Nz, but that didn't work. this gives me #Type! error
I've tried the equation above using Nz([subreport3].[Report].[subTotal3]). that throws #Size! error
I've tried, in the subreport, to use a query with an expression for either IsNull or IsEmpty and when I view it shows nothing...which I though it was supposed to say true or false?

2. Once I get #1 working, my next problem involves that same subreport. Right now my main report is setup so that each subreport is on its own page by using page breaks. If my third report is blank, then I don't want it to show and I don't want it to use the page break control. So it should either show me 3 pages if all subreports have something in it, or only two pages if the one report has nothing in it.

[Bob Fitz]

Have you tried NZ() within report3 on the textbox that creates the total. Guessing but something like: =NZ(sum(FieldName),0)

[pbaldy]

I use this:

http://theaccessweb.com/forms/frm0022.htm

[jcright]

I tried that and it didn't work. I even tried =(sum(NZ(FieldName),0)).

I gave up and took another route which is probably harder but it works and for now that is all I need. I can revisit this some other time. What I did is to write some vba code on load to test if any one of the three totals had an error so that I was only adding up the totals that existed. Lots of if/then elseif's.