Probably a very simple problem, but it's got me...

[Greg Murrie]

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]

"Greg Murrie" <gm*****@sbcglobal.net> wrote in
news:MZ*******************@newssvr14.news.prodigy. com:

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!

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.

--
Roy-Vidar