I have data in a subreport that I want to show the total of in the main body of the report. I have been tried using "=Sum(field name)", but it is not working.
Is there a way to get this to work?
I have data in a subreport that I want to show the total of in the main body of the report. I have been tried using "=Sum(field name)", but it is not working.
Is there a way to get this to work?
You put a sum in the subreport's report footer, and then in the main report just point to that. You may want this too:
http://www.mvps.org/access/forms/frm0022.htm
Thank you, I am trying that now, getting the error and trying to solve it now.
No problem, post back if you get stuck.
Thank you once again. I figured out where the error was. I had placed the text box in the Page Footer, instead of the Report Footer. Everything works fine now.