Concatinate Multiple Rows into One Field (1 Viewer)

[abbaddon223]

Hi, I know this has been asked on here before but I'm struggling to understand the methods. Any help really apprecaited please:

I have a table:

"tb_skybox_Types", with the fields, [Policy_URN], [Box_Type]

Sample:

Policy_URN Box_Type
001 Standard
001 Sky HD
002 Sky +
002 Sky + HD

I'm mail merging this, so naturally it's giving me a row per box type against which I need to be one. Desired output:

Policy_URN Box_Type
001 Standard | Sky HD
002 Sky + | Sky + HD

I'm then going to make this into a temp table, then match the URN back to the customer table to get a single row per customer. Can anyone help please? I'm okay with acces, but by no means an expert.

Thanks,

Phil.

 

[pbaldy]

How about

http://allenbrowne.com/func-concat.html

 

[abbaddon223]

Hi Pbaldy - yes that looks like it'll do the job. I keep getting an undefined function error - do you know which reference needs to be on for this please?

Thanks for your help.

Phil.

 

[pbaldy]

No reference should be required. The function should be in a standard module, declared as Public, and can't have the same name as the module.