grouping subtotals with main totals, problem still

[Lifeseeker]

Hi,

I'm really struggling with this adding the totals from subreports to the main report.

I followed Allen Browne's example, but still getting no where.

The subreport total only displays the total for the first group, but not the overall total for the subreport.


can anybody hlep me on this please? Please see the sample database I attached.

thank you

 

[Lifeseeker]

Hi,

I'm really struggling with this adding the totals from subreports to the main report.

I followed Allen Browne's example, but still getting no where.

The subreport total only displays the total for the first group, but not the overall total for the subreport.


can anybody hlep me on this please? Please see the sample database I attached.

thank you

Could anybody help me on this? I'm still trying to get it to work.

 

[stopher]

I think Allen Browne's solution only works for one subreport. But you have a continuous subreport i.e. you need to somehow sum all the text boxes. I don't know how to do this.

However, there are other options.

The first thing is, I really don't understand why you are using subreport. The layout you want could easily be achieved through a single query and using the reports grouping. So that's what I'd recommend.

Another option is to extend the query for the main report to include the detail. Then you should be able to add a total using the required field.

A third option is to use a Dlookup which should work fine but wouldn't be may favoured option.

hth
Chris