Totals in a Report

[iazcac]

I am having a problem with a report

I have subform which stores quantities and prices. I can get these to total in the report for each individual order.

However, I am having problems doing a grand total at the bottom of the report. It multiplys it by the number of records in the subform

I have attatched a screen shot of the problem

Any ideas?

 

[Fizzio]

Do the totals calculation in the subform footer and then refer to this in the main report footer.

ie

Grand Total = Reports!MainReport!SubReport.Report!TotalsControl

 

[iazcac]

OK - have created GrandTotal in the subform footer

Then in report footer have

=Sum([Forms]![plainorderitemssubform]![GrandTotal])

But this is wanting a parameter of the above when running the report

Is this what you meant??

 

[Fizzio]

Sorry, I misread your question and did not clarify my answer enough.

The correct sytax would be
=[Forms]![plainorderitemssubform].form![GrandTotal] - you don not need to sum this if you have already calculated this in the subform.

Can you clarify what you are trying to show though as I'm a little confused to why you have the main report without each order line in a subreport.

 

[iazcac]

Have stripped out my database and attatched a copy

Not your fault....Is me not clarifying my question enough!!

Any suggestions would be greatly appreciated

 

[Ukraine82]

I'm not sure what you're trying to do, but if you open your report plainorderitem in design view. Drag the fields total, glass total, and presentation box total into detail section. The text boxes you made for total are correct.

hth,
Michael