When using Summary Information for Volunteer in a Constituent query, the results are incorrect if filters are added to the summary information.
If you encounter this issue in the latest version and patch of Raiser's Edge pleasecontact support and reference this article.
Steps to Duplicate
1. Query > New Query > Constituent 2. Add criteria Volunteer > Summary Information for Volunteer > Total Number of Job Assignments greater than 0 3. Add to Output fields Name and Total Number of Job Assignments 4. Run Now 5. In sample data, Mark Adamson Total Number of Job Assignments is 4 assignments, which matches his record 6. On Criteria tab add to Summary filter Time Sheets > Date between 1/1/00-1/1/16 7. Run Now 8. Mark Adamson Total Number of Job Assignments is 72 assignments