Sub report syntax

T

Tony Williams

I have a main report rptpage2 which has a subreport rptpage3 which in turn
has a subreport rptsyndicatePage3. On this last report is a calculated
control I want to appear on the main report as well. My syntax is this
=[Reports]![rptpage2]![rptpage3]![rptsyndicatePage3]![Sum Of Sum Of
txtClientsaletot]
but I get the usual #Name error. I've looked at Help and I thought my syntax
was correct. Can anyone see what's wrong?
Thanks
Tony
 
T

Tony Williams

Thanks Allen really useful.
Tony
Allen Browne said:
Tony, see:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

The article explains what expression to use, and how to troubleshoot it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Tony Williams said:
I have a main report rptpage2 which has a subreport rptpage3 which in turn
has a subreport rptsyndicatePage3. On this last report is a calculated
control I want to appear on the main report as well. My syntax is this
=[Reports]![rptpage2]![rptpage3]![rptsyndicatePage3]![Sum Of Sum Of
txtClientsaletot]
but I get the usual #Name error. I've looked at Help and I thought my
syntax was correct. Can anyone see what's wrong?
Thanks
Click to expand...
Click to expand...
 
Top