I probably should have mentioned that there are 4 summarized fields in this CT, and there is a grand total at the very end of the CT.

It is only the ?date_end month that is getting the huge number.

I did add your formula to my summarized fields, but the numbers did not add up correctly..

Sorry for all the posts!

Hey dBlank,

Take a look at the screen photo below:
This will give you an idea of what the CT looks like.

http://i595.photobucket.com/albums/tt37/hammondrob/cr.jpg

hey dblank,

I was away for the weekend, and just saw your response now. thank you so much for your help again.

your formula worked! and yes, the 217 for john was a sum indeed.

There is just one more small issue. Check out the link:

http://i595.photobucket.com/albums/tt37/hammondrob/ct2.jpg

If you look at '08 Jun in CT1 and '08 Jul in CT2, you will notice that the RT does not pick up the 2 records in June (the equation is CT1 Jun 08 + CT1 Jul 08 = CT2 Jul 08). That problem also applies to the CT2 '08 Sept RT.

Any idea?

hard to tell but it is most likely how you have it resetting. That is in the SUmmary set up or in the last section of a Running Total.