Access-change row and columns

[Dano1234]

I have a table which has two fields: store name and customer name. I would like to change this to store name, customer name1, customer name2. To further iterate, the table looks like this now:

Joes store, Susie Smith
Joes store, Mark Jones . . .

I would like to change this to

Joes store, Susie Smith, Mark Jones

Is there an easy way to do this?

 

[ebalki]

Dano - If you are using ASP i would count the number of coulumns you have vs the number of records you need to add to your table. If the number exceeds your amount of available columns then you can use the alter table method to add another column like this:

alter table store add column customerX

let me know if this helps - eBalki