Query for displaying monthly income

Hi,

I am trying to write a query that display monthly income for a desired month. The problem is that it only shows the contracts that have started and ended in that month and not ongoing contract payments, that have either started in earlier months or have ended in later months.

I m trying this bubt their is some problem in that:

Thanks in advance

Please Login or Register  to view this content.

I m sending you the similar code according to your Query, I think u've missed something in your code.Just try this code.May be helpful to you.Just tell me if the problem solved.

Please Login or Register  to view this content.