I know this has been asked before and I've tried every one of the solutions. So here I am. I need to bring a sum from my subtotal into my main report. This is what I tried (and failed): =[Qry_Count_Unit_Awards_by_Unit subreport].[rpt_Award_Totals_by_Unit]![SumofAwards]
That is trying to just bring my sum field into the main report to use it. The first field is my subreport, the second is my main report and the third is my sum field.
Any suggestions welcome - and I'm an Access novice, so type slowly ;-)