I am trying to take a dataset that looks like this:
Table1 Table2
ID Work Hours
1 abc 123
2 abc 234
3 abc 789
4 def 112
5 def 132
6 ghi 678
and write a report that writes out each Hours per work value, like this:
abc
123
234
789
def
112
132
ghi
678
That looks so easy, even to me. But I get absolutely nothing.
Please help!
RoyVidar - 27 Dec 2005 14:28 GMT
> I am trying to take a dataset that looks like this:
>
[quoted text clipped - 23 lines]
>
> Please help!
Unless I've completely misunderstood, when you create a report through
the report wizard, base it on a query like the one you present, then in
the "Do you want to add any grouping levels" part of the wizard, select
the "Work" field, and what you wish should be what you get.

Signature
Roy-Vidar