Results 1 to 3 of 3
  1. #1
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142

    create a grouped report

    I have a report that shows each associates daily numbers.
    Click image for larger version. 

Name:	1.JPG 
Views:	20 
Size:	146.2 KB 
ID:	36189
    this works great when you only have one day to report on. When you want to see more than one day and thus get the sume and the average of all the metrics this is what happens.
    Click image for larger version. 

Name:	2.JPG 
Views:	19 
Size:	108.5 KB 
ID:	36190



    How can I create a grouped report that will sum the first four number groups and average the other three so that I can get a weekly or monthly average report?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the AVGs will in the GROUP FOOTER for each person.
    you can do it yourself with footer boxes:

    txtTotEarned=Sum(ProdTime]
    txtTotProd=Sum(ProdTime]
    txtAvg = txtTotEarned/txtTotProd

  3. #3
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    wouldn't summing and averaging the fields in the footer just give me an overall sum and average? Although that might be useful and something I can add later, What I need is a way to sum and average a particular persons metrics for a date range. Usually for one week and for one month.

    Right now when you click on the productivity report you get a pop up that asks you for the shift you want to look at. Then a start date and an end date range pop up to display the report. If you just choose one day you get the report on the top. If you choose a date range you get the report on the bottom but displaying each person one time for each date in the range.

    What I need is if you put in 11/12 - 11/18 in the date range each person is displayed once with all their metrics summed and averaged. I might have to create another query to get those numbers but I am not sure how to design that to only show the date range selected. That's why I thought a grouped report would help.
    Attached Files Attached Files

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

Similar Threads

  1. How to create a Grouped report Like Excel
    By deepakg27 in forum Reports
    Replies: 15
    Last Post: 07-06-2018, 12:23 PM
  2. A Summarized or Grouped Report
    By DMDG in forum Reports
    Replies: 1
    Last Post: 10-31-2016, 05:04 AM
  3. Replies: 7
    Last Post: 01-19-2016, 05:28 PM
  4. Replies: 11
    Last Post: 11-06-2014, 06:01 PM
  5. Replies: 2
    Last Post: 08-25-2010, 01:42 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