Here is a question I have not seen before. I have two subreports on one main report. I want to calculate the difference between a total on each report. Report A has a total gallons pumped through a system, each reading is taken daily and then totaled in the report footer. Report B has a total gallons pumped through 22 individual wells, reading sa re taken once a week and the total is calculated in the footer of report B. In the footer of the Main Report I want to calculate the difference between those two numbers. here is what I put in the unbound text box: =([Reports]![Weekly Gallons Pumped]![text11])-([Reports]![rptMWTotalUsage]![text3]) I get a #Name? error on the report. Any ideas? -- Never give up, the answer IS out there, it just takes a while to find it sometimes!