Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Dec 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subreport problems (Access 2000)

    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

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Subreport problems (Access 2000)

    If you have successfully placed controls in the page header, just move them to the detail section. I'm not sure I understand your problem.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •