Hi

I have 2 table: Products and ProductColour. Each product has serveral colour such as

Product: 7052 has "Red", "Cream", "Brown"

I want to create a label that list the product number 7052 and all the colour it has. But when I use query and label wizard it just create labels which has the product number and 1 colour on it.

For example with the product 7052, it create 3 labels, each has
7052 - Red
7052 - Brown
7052 - Cream

But I just want One label that has 7052 - Red, Brown, Cream.

Please help me some advices!
Thanks

Does this help?

http://www.mvps.org/access/modules/mdl0004.htm