workinkg hours by percent

[Mosely]

Hi guys!

Please help me!
I have a table with these fields: ID CODE 1 ; ID CODE 2 ; PROJECT NAME ; WORKING HOURS / PROJECT
Every employee has two ID CODE to identify them clearly. An employee is working on more then one project in the same month. E.g. if Joe worked on two project in october, (50 hours (33,33%)on project „A”, and 100 hours (66,66%)on project „D”) it appears in two records (rows).
How could I make a query which shows in % how much hours works in one project one employee.


Thanks


Mosely from Hungary

[weekend00]

you need 2 queries:
Query1: TotalHour
SELECT WorkHour.[ID CODE 1], WorkHour.[ID CODE 2], Sum(WorkHour.[WORKING HOURS / PROJECT]) AS TotalHour
FROM WorkHour
GROUP BY WorkHour.[ID CODE 1], WorkHour.[ID CODE 2];


Query2: percentage
Select WorkHour.[ID CODE 1], WorkHour.[ID CODE 2], WorkHour.[PROJECT NAME], WorkHour.[WORKING HOURS / PROJECT], [WORKING HOURS / PROJECT]/[TotalHour]*100 AS [WORKING HOURS / PROJECT %]
FROM WorkHour INNER JOIN TotalHour ON (WorkHour.[ID CODE 2] = TotalHour.[ID CODE 2]) AND (WorkHour.[ID CODE 1] = TotalHour.[ID CODE 1]);