Simple Query Needed

[ac916]

Hi,
I have data that I imported into access (Table1). Basically, the file shows two values with Header, Component. I need to group the Component together with a delimiter & (or any symbol) when the header is the same.
For example of what I have:

Table1
Field 1 – Header
Field 2 - Component
FG1 | SA1
FG1 | SA2
FG1 | CO1
FG2 | SA3
FG2 | CO2

What I am trying to get is

Table2
Field 1 – Header
Field 2 - Join Component
FG1 | SA1&SA2&CO1
FG2 | SA3&CO2

Thanks
Andrew

 

[cjard]

you cannot perform this kind of operation without some very convoluted, weird sql particular to the database vendor. I dont work with MS Access, but from what I know of it, it would be faster to do this operation in code.

A better question might be why do you need to do this?

 

[ac916]

Hi CJARD,

I need to group by the header to get all component in one line.
It can be

FG1 | SA1 SA2 CO1
FG2 | SA3 CO2

Thanks.

 

[cjard]

Given that you have re-iterated the question, I can only re-iterate what I said before. I have, of course, chosen not to repeat myself as my advice remains the same. Sorry