subreport problems

[Johm]

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

[Bruce Pick]

Look in Help - read about DLookup, DCount, DMin and DMax, etc.

You can use these to find data from tables that are not in the query,
not in the report's data source, etc.

You can use these values in formulas to do calculations.

Bruce
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++
To send email, remove all < > and [ ] and the junk ~ between:
[brucepick1]
< a~t >
[comcast.net]

Johm wrote:

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