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.