now the condition is i need to sum the amounts for values of field1 '001' to '004' then sum the amounts for values of field1 as '005' to '008' then sum the amounts for values of field1 as '002' to '008'. I tried using the following logic, but am facing problems with the third set of values for field1
this is fine for me... but how do i do the overlap case? ie. sum the amounts for values of field1 between '002' to '008'.
can anyone please help...
hope I'm clear. _________________ Thanks
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum