'Hide Duplicates' creates blank rows on report?

[dpmicka]

Is there a way to remove the spaces (blank rows) on a report that are created when you set HIDE DUPLICATES to YES? I have a two column report (WorkCode and HoursWorked. There are many duplicate entries under Workcode - I want the report to just show the unique codes and the total HoursWorked for each unique code. For example, my query may return a dynaset that shows A, A, B, B, B for WorkCode and corresponding values in HoursWorked of 1, 2, 1, 1, 2. I'd like the report to show that WorkCode A is 3 and WorkCode B is 4. Is there a way to do this without getting too deep into VB, etc.? I'm obviously an Access beginner!

 

[dpmicka]

Pat... Got your reply, but I'm not sure how to suppress a particular report section from printing. Also, I'm a little unclear on building the query you outlined... any clarifications would be helpful. Thanks!

 

[dpmicka]

Never mind... I got it! Thanks!