Hey,
I am creating a report to send out that will show a customers current contract information. For most customers all their products are listed under the same Quote number. A few, however, have separate quote numbers applied to different products. Currently I have it set up so that the Quote Number is in a group so everything is broken down by Customer and then by Quote Number. What I would like to do is eliminate the Quote Number group and simply have the Quote Numbers listed next to the customer as a reference. I have created a text box with the correct control source however it only gives me one of the Quote Numbers. Is there a way I can do this? Below is a simple visual showing what I would like to do. (It is currently set up like the left I would like it similar to the right)
Thanks for any help.
Customer Customer Quote Number 1 Quote Number2 Quote Number 1 Product 1 Product 1 Product 2 Product 2 Product 3 Quote Number 2 Product 3