subreport total to main report

[jedder18]

Access 2007
Windows 7


trying to get a subreport total to show on my main report
getting #error no matter how I code


Running a subreport containing a total in report footer (only field that


name of subrpt total fld subrpt
[SubRptExp].[Report]![gramtrcvd]


Any help much appreciated....

 

[pbaldy]

This works for me:

=[SubreportControlName].Report!TextboxName

 

[Mihail]

I'm wonder why you need this ?
Why you don't display the subreport total in the subreport footer ?
Just I'm wonder.

 

[jedder18]

Because the subreport is grouped and I need the totals for all the groups.

and the main report has other totals

 

[pbaldy]

So did you try the syntax I posted?

 

[jedder18]

I did try the syntax but still getting the error message
I think I need to create something that shows if null values

 

[pbaldy]

Like this?

http://access.mvps.org/access/forms/frm0022.htm

 

[jedder18]

Thank you I will give this a try...

 

[jedder18]

Well, I got it solved.
A BIG DUH moment, LOL!

created many queries to get to final result.
Sub report not needed in the end...
But, I learned along the way

Thanks for all the help.

 

[pbaldy]

Glad you got it sorted out.