Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    361

    Unanswered: Totals in Report

    I have two reports that have a matrix like layout on them. Is it possible to sum these columns on the two different report into a separate report. The Name of the two reports are Page 5 Early Term and Page 5 Report. If I name the textboxes in one of the reports could I just reference that report or do I have to associate it with a query. Thanks!

  2. #2
    Join Date
    Mar 2004
    Posts
    361
    I tired to reference them by report name and then text box name but that didn't work.

    ie =Dsum([Page 5 Report]![txtRelAug].

    That didn't work.

    Any other ideas?

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by tjarvas
    I tired to reference them by report name and then text box name but that didn't work.

    ie =Dsum([Page 5 Report]![txtRelAug].

    That didn't work.

    Any other ideas?
    Hi tjarvas,

    Have you tried creating a Report with SubReport? If you don't want that how about creating a query that gets both for you then put it out to a report?
    Just a thought
    Bud

  4. #4
    Join Date
    Mar 2004
    Posts
    361
    That may be a possibility. Let me work on that for a little while. Thanks!

Posting Permissions

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