When running a query on the hours a volunteer worked in their timesheets, the query results are incorrect. Specific timesheets are excluded from the results that are present on the record.
This issue occurs when the output fields are limited to fields that cause the line items to appear as the same and the Suppress duplicate rows checkbox is marked. For example: If only hours worked and the Volunteer's name are on the output and more than one job has the same number of hours worked. This causes Query to remove these lines that it deems duplicates.
On the Set save options tab of the query, unmark the Suppress duplicate rows checkbox.