List Group Headings

[Rustin788]

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

[June7]

Should that show Product 3 under Quote Number 2?

Denormalizing data is not easy. I presume CROSSTAB won't work because quote numbers are different for every customer. If the quote numbers were literally 1, 2, 3 for each customer, then those could become the column headers in a CROSSTAB but I doubt quote numbers are like that. Generating this quote sequential ID within each customer group can be done and then build CROSSTAB. However, building a report to run perpetually based on a CROSSTAB is also not easy because of its dynamic nature. http://allenbrowne.com/ser-67.html