Access report with multiple subreports

[duncanmcl]

How can I refer to each subreport when one to many exist on a report. Need to add a field from each to a totals by the main from. Seems I can't use the sum function on a grouping break. So thing I can add each from a computed field on the main report, but now sum only includes the first subreport.

Is each subrpeport have an index in the collections that I can refer to?

Thanks

[nico5038]

Hmm, will be easier to generate GroupBy query on a UNION query to total the subform field(s) and show that on the mainform by joining this GroupBy/UNION query with the mainreports query.

Just start with a query with the linking key of the mainreport for each subform like:

select ID, ValueField from tblA
UNION
select ID, ValueField from tblB
etc..

Now save this and create a GroupBy on the ID and a Sum() on the ValueField.
Finally save this query and JOIN with the mainform's query.

Getting the idea ?

Nic;o)