subreport problems 1

[primerov]

I have 2 queries, qryinput and qryoutput.I have to substract the cartons from qryinput from the qry output.I cannot do it with a third query since the queries
are incompatible, and i want to do it with subreport. If i place a control in the page header section like:
=rptInput![Grandtotalcartons]
i receive the figure only for the first product and not for the all products.If i succeed to place controls in the detail section for each product for the
both subreports, and then substract for each product, then my case is solved.But this can not be done with my skills and i am asking for help

 

[dhookom]

Do you have report total text boxes in your subreports?
Are you hoping to add up all values from the subreports and then subtract them in the main report?
Does your main report have a record source?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.