Results 1 to 7 of 7
  1. #1
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57

    creating a report that displays average for availability of network categorized by departments

    I created a table with a table which records date task was created, tasks completed by departments and the availability in % of the network. I want to create a report that calculates the average availability for each department.



    i created a query with fields Department from table Department total:group by, Availability from table Main total;Avg and Date from table Main total:group by and a criteria:Between [Enter Start Date] And [Enter End Date]

    When i create a report based on this report i get a really long list for a report

    instead i want my report to display

    Dept 1 - average availability Dept 1


    Dept 2 - average availability Dept 2
    Dept 3 - average availability Dept 3

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Try changing a Group By to Where on the date field.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Perhaps you could show us your tables and relationships as a jpg.
    How do you determine Network availability?

    You might get more focused responses if you tell readers about your business, its processes and provide a sample of your inputs and expected outputs.

  4. #4
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57

    Talking

    Quote Originally Posted by pbaldy View Post
    Try changing a Group By to Where on the date field.
    Thanks. That was really helpful.

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    joym is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    57
    just a quick question on this i am able to calculate average for each departments however for departments with no tasks will not be calculated. or displayed Is there a way to show this on the report i.e say department 1 did not have any task as there was nothing wrong in there system or work. So their availability would be 100%, however since the calculation is done on records on the table it disregards any department without a task thus availability isnt shown

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can try including a "departments" table with a join that includes all departments. Might take 2 queries.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Creating a subform which displays values from a table
    By marcvanderpeet12 in forum Access
    Replies: 1
    Last Post: 03-03-2014, 01:04 PM
  2. Replies: 27
    Last Post: 08-14-2012, 09:05 AM
  3. Creating a local network Database
    By blukit01 in forum SQL Server
    Replies: 1
    Last Post: 03-15-2012, 01:20 PM
  4. Replies: 10
    Last Post: 03-02-2012, 11:06 AM
  5. Sum of a categorized filed
    By Costa in forum Reports
    Replies: 0
    Last Post: 02-24-2010, 07:34 AM

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