Hi!

I want to count loan_num nad how many accounts by branch something like the picture of excel. if i need something else tell me.

thanks appreciated

If all that you want is the count of Loan number per Sercusal per Region then they are the only fields to select counting the first and group by the last 2.

I posted the above on your previous thread, did it not point you in the direction to go?

Brian

i think i put it the wrong way and gave me various errors. and i want to export this to excel if this is possibble.

who can help me in this matter

I am not sure how to get all those figures. Maybe someone else can help - but I think a starting point would be some kind of a GROUP BY clause, something like this:

SELECT Branch_Number, Count(Loan_Num) as LoanCount
FROM DBA_INC_LOAN_Bank
GROUP BY Branch_Number