Combining data from different records

[Access_Help]

I am looking for a method to combine the data for a particular field from each record into a separate field.

Example:

Result:
Seattle, WA 98104, Chicago, IL 60605, Los Angeles, CA 90010.

How can this be achieved?

 

[theDBguy]

Hi. Have a look at this simple function. Hope it helps...

 

[Gasman]

ALso look at the Similar thread at the bottom of the page. I am sure someone asked this very question just the other day?

 

[vba_php]

https://www.access-programmers.co.uk/forums/showthread.php?t=189359

 

[Fira_g]

I use query to concatenate fields from parent and child tables as in the image bellow:

 

[Fira_g]

I see theDBguy already posted a link with solution

 

[Access_Help]

Hi. Have a look at this simple function. Hope it helps...

This is my first time experience with modules, not sure where I have gone wrong, I am sure it is something simple

I am getting an error....anyone please help ?

File attached.

 

[theDBguy]

This is my first time experience with modules, not sure where I have gone wrong, I am sure it is something simple

I am getting an error....anyone please help ?

File attached.

Hi. Sorry for the delay. Looks like you modified the module. You didn't have to. Please take a look at the attached modified version of your db and let us know if this is what you wanted. Cheers!