TOTALLING ON A REPORT

[geeves1293]

I have a form with a subform. The subform has a sum text box in the footer
which is totallying the line totals in the detail of the subform. There is
another text box in the main form connected to the text box in the subform
footer showing the output.

What I need is the total of each form (order) on a listing report, showing
me all my 'order book' totals, then give me a complete total of my 'order
book'.

Overview:
1 Line Total (that takes the qty * unit price) - in the detail of subform.
2 Order Total (that sums all the line totals) - in the footer of subform.
3 Order Total Output (same as the order total) - on the main form.
4 Order book Line total (Order Total from each subform) - in order book
report.
5 Order book Total (The sum total of the Order book Line Totals) - in order
book report.

I already have 1 - 3. Just got a bit stuck on 4. Number 5 should be quite
easy enough once 4 is complete.

Can anyone help me out here please?

Geeves1293

 

[Duane Hookom]

I expect you mean subreports rather than subforms. I never print forms.

The method that I recommend is to create totals queries that group by your
group levels in your main report. Total the appropriate expressions in these
totals queries. Then join these queries into the Record Source of your main
report. This makes all of your totals available in the main report record
source.