Split the Records so now our Participation Report isn't accurate.

So your reports are now over counting participants or under counting? I imagine over counting, but I'm not 100% clear on what the problem is. 


Could you describe better how you're recording participation and weekly giving and that kind of thing? A screen shot of maybe one of your query criteria panels and naming the specic report you're piping to would help.


Or maybe this is a quicker solution that I'm making it out to be. In your constituent query, you obviously have your criteria set to look for the stuff you want to look for as it was working in the past. Now in your query, create an OR statement with parentheeses that uses all of the same criteria as you had before, but pull all of it from within the Spouse tree. You should end up with basically:


Constituent matches critera:

A

B

C
OR (Spouse of constituent matches criteria:

A

B

C)


Then in your report, tell it to only include head of household. The raw count from the query may be wrong, but report should only show you total number of households that showed up in the query. I'm assuming what you want is total households because if you were just counting individuals then you shouldn't be having a problem.