Skip to Content
0
Former Member
May 04, 2009 at 09:45 AM

data in the report

22 Views

hi,

I have the following data in the table

Account_Num Payment_type

TEST0001 Credit Card

TEST0001 Auto Debit

TEST0001 EFT

TEST0001 Credit Card

TEST0001 Cash

TEST0001 Auto Debit

ACC00000016 Credit Card

ACC00000016 Auto Debit

ACC00000016 EFT

ACC00000016 Credit Card

ACC00000016 Cash

ACC00000016 Auto Debit

ACC00000017 EFT

ACC00000017 Credit Card

ACC00000017 Auto Debit

ACC00000017 EFT

ACC00000017 Credit Card

ACC00000017 Cash

ACC00000017 Auto Debit

in the report data look like,

accountno cash eft autodebit credit

ACC00000017 1 2 2 2

ACC00000016 1 1 2 2

TEST0001 1 1 2 2

for each accountnum how many payments has been occured their count.

please can provide solution,appreciate u r solution.

thanks

sekhar