Hi. I have a main report with 3 separate sub-reports. Each subreport consists of separate data but has the same columns headers in each. I am calculating a grand total in the report footer of each of my subreports but I also need to calculate a grand total by adding subreport grand totals and would like to add this grand total to my main report page footer. I'm having a hard time trying to figure this out.
Would it make sense to create a 4th subreport that carried my grand totals only? I'm having trouble putting that logic together. Is there a better way? I seem to recall reading that there is some limitation to linking totals from subreport to main report in access. I'm attaching a screen shot of my report as an example of what I'm trying to accomplish.