Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: report questions (conditional sums et al)

    hi, I have a couple of questions about reports:
    1. I have a couple of reports which provide a grand total (running sum) at the bottom, and I need to copy these totals over to another report where further calculations will be performed using these totals. How can I do this? Is there a way maybe that I can store that total value in a table when the report is opened (one of the first ones) that can then be retrieved to put on the 2nd report (with all these totals)

    2. Is there a way to do a conditional running sum on a report ie. for each record, only add its total to the running sum if the contents of another field for that record meet some criteria?


  2. #2
    Join Date
    Jul 2004
    Southampton, UK
    I would write an aggregate query based on your source data (not on a report). Then use the aggregate query as the source data for your new report.

Posting Permissions

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