Anyway I'm building a report and i have a problem. I have a report where I have to report on peoples income and I'm have a date range problem

-------------------------------------------------------------------------

child supplement  $318   sep/1/2008/      jul/31/2009

 

student loan  $805  mar/1/2008   feb/28/2009--(only need jan to feb)

student loan  $1098  mar/1/2009  jan/1/2010---(only need mar to april)

---------------------------------------------------------------------------

Now I set up date prams and selected jan1/2009 to april30/2009

Im doing totals on the months selected for each record.so i did a datediff

DateDiff("m", {?FromDate}, {?ToDate}+1)

to get the number 4 and then multiply to the total to give me a 4 month total.so for the child supplement im getting a total of $1272 which is right but for the other two records(student loan) I only need two months out of each record to get the total but my datediff is always calculating 4.does anybody have any suggestions that could help me.maybe im using the wrong function or setting up my forumla wrong. the date ranges could change also so static numbers in my forumula will not help.have to distinguish when there are different date ranges.