winxmun
09-21-2008, 07:55 PM
Hi,
May I know how to do a count with the data provided as follow:
Ref No. Date
HDB/Pur/153 01/09/08
HDB/Ref/153 02/09/08
PHL/Pur/153 01/09/08
PHL/Ref/153 02/09/08
PHL/Pur/154 01/09/08
System to auto count as follow:
HDB
Date No. of appln
01/09/08 1
02/09/08 1
PHL
Date No. of appln
01/09/08 2
02/09/08 1
:dunno
May I know how to do a count with the data provided as follow:
Ref No. Date
HDB/Pur/153 01/09/08
HDB/Ref/153 02/09/08
PHL/Pur/153 01/09/08
PHL/Ref/153 02/09/08
PHL/Pur/154 01/09/08
System to auto count as follow:
HDB
Date No. of appln
01/09/08 1
02/09/08 1
PHL
Date No. of appln
01/09/08 2
02/09/08 1
:dunno