There is only 1 record per item in my table but the report prints 2 detail lines per record and not consecutively. My database shows the records in a form. In the form there is a print button which displays the report version of the same table for printing. The form displays 1 line per record properly but the report has exactly 2 detail lines per record from the same table.
The report uses 2 groupings, by record type, then by department. In the department group heading, the =sum(hours) also adds each record twice. The subtotals match the double display of each record.
I have attached a sample of the report and have no idea where to start to fix this problem. It seems so straight forward.
Thanks for the help!