Skip to Content
0
Former Member
Dec 29, 2007 at 02:07 PM

COUNT of OPen, Inprocess, Completed

19 Views

Hi

I have records like below

__0MATERIAL STATUS_ DATE_

M1 OPEN 01/11/2007

M1 INPROCES 15/11/2007

M1 CLOSE 30/11/2007

I want the COUNT(number of open , number of inprocee, number of close) liie below

__0MATERIAL STATUS_ DATE_ No. Of. Open No.Of.InProcess No.Of Completed

M1 OPEN 01/11/2007 1 0 0

M1 INPROCESS 15/11/2007 0 1 0

M1 CLOSE 30/11/2007 0 0 1

Pls let me know how can i get the COUNT of 'No. OF Open' , 'No. Of. InProcess' , 'No.Of Completed' .

regards

kumar