From multiple records to a single one

[Catoal]

Hi,

I have this kind of table

Company|C_name|C_Tel|...
A|John|1|
A|Paul|2|
A|Ringo|4|
B|John|2|
B|Jean|1|
C|Don|5|
C|Franck|9|

and I need to have this :
Company|C_name_1||C_Tel_1|C_name_2||C_Tel_2|...
A|John|1|Paul|2|...
B|John|2|Jean|1|...
C|Don|5|Franck|9|...

with up to ten contact name for the same company.

Any idea about how to do that?

 

[Remou]

You will find one or two FAQs on concatenation, and numerous posts in the Access fora*, but I think the real question is why do it? Have you looked at relational design (

http://www.r937.com/relational.htm)?

==========================================
* Microsoft: Access Forms Forum: forum702
Microsoft: Access Modules (VBA Coding) Forum: forum705
Microsoft: Access Queries and JET SQL Forum: forum701
Microsoft: Access Reports Forum: forum703
Microsoft: Access Tables and Relationships Forum: forum700
Microsoft: Access Other topics Forum: forum181