Sum across sub-reports

R

Razor

Hi,

I have a report containing 3 subreports, without any
master/child fields specified. The third is bound to a
totals query.

Is it possible to sum across the subreports in the report
without using a separate subreport bound to a totals query?

I've specified master/child fields in form/subforms before
but how would I do so in report/subreports?

Thanks,
Razor
 
S

Steve Schapel

Razor,

I am not 100% clear on what you are really trying to achieve. But
here is some information which might help you... If you put an
unbound textbox on the main report, you can get it to display or use
the value of a subreport control, by putting the equivalent of this in
its control source property...
=[NameOfSubreport]![NameOfControl]

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top