Summarize data

**maxmuster97** · 10-11-2022, 11:08 AM

I need a query in Access with which I can combine the following tables.
I have a table with two columns.

Table1:

Please Login or Register  to view this content.

How do I get SQL to combine 112 and 332 so that something like this comes out?

Please Login or Register  to view this content.

I tried this code, which unfortunately does not work

Please Login or Register  to view this content.

**alansidman** · 10-13-2022, 12:12 AM

Export your data to Excel and then in Power Pivot create a measure using Concatenatex

Here is a tutorial: https://sfmagazine.com/post-entry/ju...a-pivot-table/

Re: Summarize data