account PR_Mons credit debit closinbal
=======================================
E2674 apr 3000 00000 -3000
R7890 jun 0000 50000 5000
E9700 feb 5000 0000 5000
E2674 apr 3000 00000 -3000 ======>expextingh output
R7890 jun 0000 50000 5000
E9700 feb 5000 0000 5000
condition:
**while account "E" means=cr-dr inclosing bal
as the same account "R" means=dr-cr inclosing bal
how to make query friend..... suppose I m giving from one month to another month it display the month in ouput of account......