query/report

[equisbert]

Greetings,
I inherited a DB and I have the following problem:
I have a simple table:
ID Value
1 a
1 b
2 s
2 i
2 a

as you can see this table has two columns, ID and Value. Each ID can
have one or more values, and each value can occur in one or more IDs.
I have been asked to produced a report showing each id and all its
corresponding values, ex:
report:
The values of 1 are: a, b
The values of 2 are: i, a

How can I accomplish this?
Thanks,
Q

 

[Wayne-I-M]

Create the report and use the grouping option. Place the ID field in the
group header and the Values in the details section.