Results 1 to 2 of 2
  1. #1
    GregShah is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Canton, Ohio
    Posts
    60

    Using the Calculated Report Sum in the Detail Footer

    I have a report tracking production counts for each employee. I total the quantity for each employee and this appears in the detail footer.



    I also total the production from all employees and this figure appears in the report footer.

    I would like to calculate the percentage of production for each employee using the employee production divided by the total monthly production. How do I designate the total monthly production in the detail footer.

    Thanks,

    Greg

  2. #2
    GregShah is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Canton, Ohio
    Posts
    60
    I used the text box designations and the calculation worked.

    Thanks,

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Detail Section Being repeated Below Footer
    By rjsbinders in forum Access
    Replies: 1
    Last Post: 01-29-2020, 04:42 AM
  2. Replies: 3
    Last Post: 03-08-2019, 03:25 PM
  3. Replies: 3
    Last Post: 11-17-2015, 05:49 PM
  4. space between Detail and Footer
    By ConfusedMike in forum Reports
    Replies: 5
    Last Post: 11-17-2015, 05:46 PM
  5. Totals of Calculated Fields in Report Footer
    By rrciesla in forum Access
    Replies: 2
    Last Post: 12-13-2014, 01:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums