Join query Problem

[willy292]

Thanks wholeheartedly for everyone who try to solve my problems
I have two query called query1 and query3 having the following
structure

Query1
Project Name, Project desc, start Date,end
date,sponsor, TeamA, TeamB, Team C

The value of TeamA,TeamB,TeamC is -1
or 0 which is orignally the Yes/No boxes from table , A project can be catered
by more than 1 team together which means TeamA and TeamB or even TeamC can be -1
on the same row.
This query show the outstanding
project.

Query3


Project Name, Working
hr,Date,TeamA,TeamB,TeamC

This query show the working hr within weeks in
each team, only One team
can be allocated for each record, TeamA,TeamB,TeamC
is Yes/No box.
Not all the outstanding projects appear in query 3 because
some project may be pending.

Aim
Return for each project, how many working hours have been spent for each team

[June7]

Data is not normalized structure so this will be tricky. Try:

SELECT [Project Name], Sum(IIf(TeamA, [Working Hr], 0)) AS TeamAHrs, Sum(IIf(TeamB, [Working Hr], 0)) AS TeamBHrs, Sum(IIf(TeamC, [Working Hr], 0)) AS TeamCHrs FROM Query3 GROUP BY [Project Name];