By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

subreport problems

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.