Running an access query

[Armele look]

hi,

I have a table with multirecords, I would like to put the data in one row,
for example, I have a customer who has address 1, address 2 and address 3,
each address creates 1 record, how do I run a query that return the customer
name and address 1, address 2 and address 3 on one line?

 

[Lance]

So your table looks like:

Customer Address
Bob Bob's Address #1
Bob Bob's Address #2
Bob Bob's Address #3

????

Are there any other fields in the table?

 

[Armele look]

yes there are. but it's only the address field that has more than one address

 

[Lance]

And address field is like street address.. not including city state and zip
stuff?
Is there always 3 records for each customer?