Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: One report - Two Different Sections

    I have data in which there are multiple tasks that can be assigned for one record number. I need a report that will:
    A. Summarize each task that is due regardless of which record it is in (duplicates)
    B. Show a detailed veiw of each record that has items due (no duplicates)

    I am not sure how to go about it. I have one table that contains the summary information which contains some calcualted values. I also have a query that queries the main table for records that have items due. I just don't know how to put this all together...
    Help appreciated.

  2. #2
    Join Date
    Aug 2004
    If I read the question correctly you want two reports joined together.

    what I do is create the first report and a sub report in the footer of the first report for the secord report.

    ie Report 1: Recordsource = detail records due

    header detail records due
    report header Rec No: event: time date....
    detail 1 123 12:12
    1 222 22:22
    3 333 33:33
    report footer
    insert sub report (which is defined with the other record source)

Posting Permissions

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