Combine multiple rows into one single column

[RayJ]

I am trying to build a query from a table (Tbl_XYZ) that will give me the information for the primary key all in one row rather then creating dups for that primary key and showing up with multiple rows. Example below.( this is just a sample)

Account Number	System_Name	Table_Name
012345	DW	Customer
012345	DW	Sales
012345	DW	Address
012345	AWS	aws_Cust
012345	AWS	aws_product

I was thinking creating 2 separate tables for System_Name and Table_Name but it would still give me values in different rows since the table names are different.

My expectation :

Account Number	System_Name	Table_Name
012345	DW	Customer / Sales / Address
012345	AWS	aws_Cust / aws_product

Any help with this would be greatly appreciated.

I am using MS Access 2013.

Thanks.

 

[MajP]

Code Snippets

There are several functions. I like this version because it is simple. Search "concatenate records"

 

[Pat Hartman]

In reality, what you have belongs in THREE tables not one. Then you have no duplicate primary keys.

As Maj suggested, there are concatenation functions that can return coma separated lists in one column but you would NEVER store your data this way.

 

[RayJ]

In reality, what you have belongs in THREE tables not one. Then you have no duplicate primary keys.

As Maj suggested, there are concatenation functions that can return coma separated lists in one column but you would NEVER store your data this way.

I am using this query just for a reporting purpose. I wanted to transfer this data on an excel file without creating dups.