On my report I am using subreports and subqueries. But I have two fields outside of those "sub-objects". I am working with Project Mgrs and trying to find the number of months (over six months MAX) that they are delinquent.

What I am getting instead is the sum of each Project for each Project Manager that is delinquent. So for example, PM Jim has five months of data and twenty projects. If none of his projects were delinquent then he would get a "0" if even one project were delinquent he would get a "1". Then I would like to sum up the "Number of Months" a Project Manager has been delinquent with even ONE account. And in my example the maximum PM Jim could have is five months delinquent and the minimum is zero months. He could be delinquent all months but the final (fifth month) so he would have four "1"'s or "4". Instead I am getting numbers like "84" or "90" when I should be getting 4 instead.

These are outside of my subqueries/subreports.

Can anyone help??

Thanks,

Brett

Can you post the sql for your report?