ordinal autonumbers in a query result?

[JamesSF]

Hello

I have a table with a foriegn key and a list of addresses.. I want to
export the data into excel with the the first 3 address in a column format.
Basically i an taking a data from a row format into a column format.

FROM:

ID ADD
1 123 Main ST
1 234 Street
1 567 Main St
2 123 Main st
2 679 Main st
3 981 Main St

TO:

1 123 Main ST 234 Street 567 Main St
2 123 Main st 679 Main st
3 981 Main St

So that the resultant table has only 1 row per ID. How can you do this???

Thanks in advance
JamesSF

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/modules/mdl0008.htm at "The Access
Web" helps.