Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    8

    Unanswered: % of Total in Report

    I'm trying to calculate the percentage of total records within a given date range where a certain criteria is met for a field and show it in a report. I don't want anything in the report except the final percentage to show. I will be doing the same calculation on other fields with different criteria for the same date range in the report.

    For example, where the value of the "Orders" field is either "Booked" or "Closed" show the percentage of all "Closed" orders between 1/1/2004 and 3/1/2004.

    Any help is much appreciated!

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    create a non-visible field in the report footer containing =sum(yourfield) then reference the CONTROL NAME in your detail as =(yourfield / yourSumControl)
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Mar 2004
    Posts
    8
    That put me on the right track. Thanks for your help!!

Posting Permissions

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