JamesMcS
Keyboard-Chair Interface
- Local time
- Today, 09:11
- Joined
- Sep 7, 2009
- Messages
- 1,819
Hi everyone, hope the weekend was fun....
I've got a report which lists sales figures by Brand. Under Brand there are a certain amount of manufacturer numbers, the table is organised thusly:
Brand_ID, Manufacturer Number
1, 12345
1, 67890
1, 09876
1, 54321
2, 55555
2, 66666
2, 77777
So, what I want to do is have one text box in the header of the report to show the manufacturer numbers that fall under that brand, separated by a comma.
Is this possible? My first thought was reading each manufacturer number into an array of some sort but I can't quite see it clearly in my head.... would that be the right way to go?
I've got a report which lists sales figures by Brand. Under Brand there are a certain amount of manufacturer numbers, the table is organised thusly:
Brand_ID, Manufacturer Number
1, 12345
1, 67890
1, 09876
1, 54321
2, 55555
2, 66666
2, 77777
So, what I want to do is have one text box in the header of the report to show the manufacturer numbers that fall under that brand, separated by a comma.
Is this possible? My first thought was reading each manufacturer number into an array of some sort but I can't quite see it clearly in my head.... would that be the right way to go?