>I have a table that has 2 fields, one is the group name and the other is the individual items of the group. I need to create a two-column report similar to the following (need not to be the same)
>
>Group A Group AA
>Item1 Item1
>Item2
>
>Group B Group BB
>Item1 Item1
>Item2 Item2
> Item3
>
>etc.
>
>Can anyone help? Thanks in advance.
>
>
>Chu
Chu,
The easiest way is to design a cursor containing the data in the correct order so one record = one line. It'll take a little design work, but I've done it for a couple reports.