Records in array

[daze]

I want to have different dates appear in column next to customer.

I have lot of customers which items arriving on different days. So now I'd like to have them organized in a way that in one column (or string) there is customer’s name and in next dates when items arrived divided by (,)

Obviously it would go in to new table (and that is fine), but don’t know how to accomplish that.

I know how to make rows appear in one column (string), but for all of the records (i.e. emails from all customers are in one string).

Any ideas?

 

[Steve R.]

First, is your database setup as a relational database?

At a minimum you would have a customer table and and order table linked by the customer ID. The order table would hold the delivery date. You would then use MS Access query builder to list the customer and delivery date (ascending or descending).

 

[daze]

Thanks for reply.

Yes, I've made that query already. That is not an issue.

Not sure how to go from there?

Table Orders is main table of course, and customers table has relationship to it.

Now how to make (new table or string) to have dates lined up one next to other divided by (,) in same column for the same customer (next to customer name) and do that for all of them together?

I've attached picture how I'd like it to look (made it in Excel spreadsheet).

 

[vbaInet]

Ok, you don't need a new table. Have a look at this link:

http://allenbrowne.com/func-concat.html

 

[daze]

After some testing, errors and trials finally made exactly what I wanted.

Thanks vbaInet.

 

[vbaInet]

Glad that worked for you.