hi friends,

thanks for giving the reply to me.

as my scenario is to calculate no.of. months in that table. (for example milk is billed on more than 3 times in april when i calculate as months means it ll '1' as the same i want to calculate a whole year how months that should be billed on that particular customer)

Actual Table looks

Custmoer NO product name billed date

50 Biscuit 1/4/2013

50 Milk 10/4/2013

50 Milk 11/4/2013

50 Curd 15/4/2013

50 Biscuit 14/4/2013

50 Milk 16/4/2013

50 Curd 21/4/2013

50 Biscuit 19/4/2013

50 Curd 26/4/2013

50 Milk 28/4/2013

50 Biscuit 30/4/2013

40 Biscuit 1/4/2013

40 Milk 10/4/2013

40 Milk 11/4/2013

40 Curd 15/4/2013

40 Biscuit 14/4/2013

40 Milk 6/4/2013

40 Curd 21/4/2013

Expecting Output

Custmoer NO product name billed date

50 Biscuit 1

50 Milk 1

50 curd 1

40 Biscuit 1

40 Milk 1

40 curd 1

the actual table is refers the product billed for month of customer .....

now my expecting output is

How many products i billed for each customer wise ?