Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report in 2 columns (Access 2000)

    Can you help me build a report with 2 coloumns .The report should cntain the list of the products, with control productid and each product must contain 2 coloumns
    With Suborder = 1 and suborder = -1
    The rows should contain orderid as the first control.
    For example the report should read :
    ProductId
    With suborder NoSuborder
    Orderid,sum,etc orderid,sum,etc
    Tottal sum total sum
    I am applying an attachement with my efforts
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report in 2 columns (Access 2000)

    You can change the query to a crosstab query and create a report based on the crosstab query. See attached version.
    Attached Files Attached Files

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Posts
    537
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report in 2 columns (Access 2000)

    Thank you Hans for the wonderful and neatly writen solution.The report is simply fabulous.I want to sum up the resuls after each product,how could i do it ? If i write = Sum([-1]) in the report footer, it sums up all the quantities, and i want to sum up the quantities for each product separately.For example separatey for the product aaa, separately for the product bb etc.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report in 2 columns (Access 2000)

    Open the report in design view.
    Activate the Sorting and Grouping window.
    Click in the ProductID row.
    You'll see that Group Header is already set to Yes.
    Now also change Group Footer from No to Yes.
    This will add a group footer section for ProductID to the report. You can place the text boxes that sum the [-1] and [0] fields in this group footer.

Posting Permissions

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