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

 

[Ron_dK]

You might take a look at this thread :

http://www.access-programmers.co.uk/forums/showthread.php?t=106426


Hope that helps.

 

[ac916]

Thank you Rak

Thanks a lot Rak.