Grouping(?) problem

[Johnny Drama]

Hi all,

I'm trying to generate a report that's pulling data from two tables. The first table contains high level tasks (TaskID, Task) an the second table contains related sub tasks (SubtaskID, Subtask) with multiple sub tasks relating back to each high level task.

I'm trying to get the report to generate as follows:

Task One
Subtask
Subtask
Subtask

Task Two
Subtask
Subtask
Subtask

but when I run the report I get:

Task One
Subtask

Task One
Subtask

Task One
Subtask

Grouping on the task field doesn't seem to help.

Any ideas?

 

[vbaInet]

You group on TaskID field, not the Task field. And the grouping should be done on the Report not in the query.