ordinal autonumbers in a query result?

  • Thread starter Thread starter JamesSF
  • Start date Start date
J

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
 
Back
Top