hi,
I am in good progress to retrieve the data now , but I have one problem, how to
split each summation for each month
select sum(e.e_to) , e.ac_cr, a.ac_ename
from entry e inner join ac_idx a on (e.ac_cr = a.ac_id)
where e.mov_date between '01/01/2010' and '10/10/2010' and AC_CR between
'01-01-001' and '31-05-015'
group by e.ac_cr , a.ac_ename
order by e.ac_cr
I want to split the Mov_date's summation in each month
mov_date(for jan) , feb, mar..... etc till the given month
the form contains dropdown box contains the 12 months to be selected for the
period starting from jan and ending in the select month, this selected month is
the upper (last moth) of the period.
please any hint could be useful
[Non-text portions of this message have been removed]
