Hello
I know this has been asked before, but I just can't get it too work for me.
I'm trying to use the Allen Brownes ConcatRelated, but not sure if that is needed for this or not.
I have a database with pipes, and their ids, in this I also have a column with the amount of observations on a giving pipe. These observations are on the same pipe but in different rows. I would like to concatenate this into one cell.
To start of with I have two identical set up queries, with the same columns and types in them, these I join in a union query.
Then I want to create a query based on that Union where i concatenate the aforementioned rows.
Probably easier to show in a picture:
Union query is EksportOverblik, where I would like to concatenate the cells Antal observationer if they have the same delledning.
This is what I tried so far.
Concatrelated("Antal observationer fordelt på kriterie/type";"[EksportOverblik]";"DelledningsID = " & [DelledningsID])
The picture would then read.
Diameter Ledningsmateriale FysiskIndeks Antal observationer fordelt på kriterie/type Saneringsmetode Saneres/Vurderes Bemærkning DelledningsID LedningsID 250 Beton 8,8 VA: 2, RB: 3 Column is irrelevant so will be deleteddelete 383 383 550 Beton 8,8 VA: 2, PH: 3 Column is irrelevant so will be deleteddelete 399 399