How to build query

[kashif.special2005]

Hi,

I have a table like Access below

Client TCO_FCO_Case Closed_in_5 Day WTD MTD QTD YTD
7538 1 1 0 0 1 1 1
7538 1 5 0 1 0 1 1
7538 0 1 0 0 1 0 1
7538 1 0 0 1 1 1 1
7538 1 7 1 0 1 1 1
5424 1 8 0 0 1 1 1
5424 1 0 1 0 0 1 1
5424 1 8 0 1 1 1 0
5424 0 8 1 1 1 0 1
5424 1 6 0 0 1 1 1

And from above table I want results like below.

Client Period Sum of Closed_in_5
7538 Day 7
7538 WTD 5
7538 MTD 8
7538 QTD 13
7538 YTD 13
5424 Day 0
5424 WTD 8


5424 MTD 22
5424 QTD 22
5424 YTD 14

Criteria for Sum of Closed_in_5 for each client.

For Day:- Day should be 1 and TCO_FCO_Case should be 1.
For WTD:- WTD should be 1 and TCO_FCO_Case should be 1.
For MTD:- MTD should be 1 and TCO_FCO_Case should be 1.
For QTD:- QTD should be 1 and TCO_FCO_Case should be 1.
For YTD:- YTD should be 1 and TCO_FCO_Case should be 1.

I am totally confused, how this result will come.

Please help.

Thanks & Regards,
Kashif.

[Robeen]

Client	Period	Sum of Closed_in_5
7538	Day	7
7538	WTD	5

How did you get the 7 & the 5?

[kashif.special2005]

Hi Robeen,

Thanks for reply,

from top most table condition,

For Day:- Day should 1 and TCO_FCO_Case should be 1 then sum column Closed_in_5 Day.
For WTD:- WTD should 1 and TCO_FCO_Case should be 1 then sum column Closed_in_5 Day.
and wise versa.

Thanks,
Kashif.