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

[joym]

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

[pbaldy]

Try changing a Group By to Where on the date field.

[orange]

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.

[joym]

Try changing a Group By to Where on the date field.

Thanks. That was really helpful.

[pbaldy]

No problem.

[joym]

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

[pbaldy]

You can try including a "departments" table with a join that includes all departments. Might take 2 queries.