Generate report on the basis of various summations

[maxim1]

Hello. I have a big table of data (around 30,000 entries) indicating labour hours of employees at different projects.
For example, an employee John has worked 12 hours at Project A, which belong to Programme B. John is a manager.
An employee Steve has worked 7 hours at Project C which belongs to Programme D. John is a specialist.
An employee Sarah has worked 10 hours at Project E which belongs to Programme F. Sarah is an engineer. and so on.

I need to calculate labour hours and to sort the information by project, programme and job. For example, I need to find out the total hours spent for Project A, C, E etc, how many hours in total were spent for Programme B, D, F etc... How many hours were spent by managers, specialists and engineers.

So you can guess that there are many projects under different programmes and I need to sort out the data. Eventually I need to know how many hours were spent for each programme and for each project etc.

I use the filter in my table and the necessary data perfectly is shown. I wondered where it was possible to show all the required data in one report? So one report will contain Project A - xx hours, Project C - xx hours etc.. then there would be another report sorting the data by programmes: Programme B - xx hours, Programme D - xx hours... then another report showing how many hours were spent by managers, specialists and engineers etc..

I hope it all makes sense. hope someone can help.

 

[plog]

Sounds like you need an aggregate query (https://www.599cd.com/tips/access/aggregate-query/). Can you provide sample data? Give me 2 sets:

A. Starting sample data from your tables. Include table/field names and enough sample data to cover all cases.

B. Expected results. Based on the data in A, show me what data should show in the final report.

 

[maxim1]

Hi. Thanks for your reply.

A. Attached is a sample data excel file. I hope you can import it to access without problem. There are four columns: Date, Hours (this is what I need to calculate), Job (this contains numbers and each number has a unique name but this is unimportant. you will see this in word), Programme name (everyone is assigned to a programme)

B. This file is what I am looking for. Don't collate the number of excel and word - they will not match. This is just to get an idea what I want to do. So you will we that the report is divided into six programmes (p0, p1, p2, p3, p4, p5), each programme has groups of employees (they are sorted by their role: management, engineering etc). I need to find out the sum of hours that each group has worked.

I hope it makes sense. Let me know if it doesn't.

 

[plog]

No ideas, give me actual data. 2 sets:


A. Starting sample data from your tables. Include table/field names and enough sample data to cover all cases.

B. Expected results. Based on the data in A, show me what data should show in the final report.