Combining data from different records (1 Viewer)

A

Access_Help

Registered User.

Local time

Yesterday, 18:06

Joined

Feb 12, 2005

Messages

136

• Nov 19, 2019

• #1

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?

 

Attachments

• 
  Hroup.JPG

  24.4 KB · Views: 198

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 18:06

Joined

Oct 29, 2018

Messages

21,467

• Nov 19, 2019

• #2

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

 

Gasman

Enthusiastic Amateur

Local time

Today, 02:06

Joined

Sep 21, 2011

Messages

14,265

• Nov 19, 2019

• #3

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

Forum Troll

Local time

Yesterday, 20:06

Joined

Oct 6, 2019

Messages

2,880

• Nov 19, 2019

• #4

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

 

F

Fira_g

Registered User.

Local time

Yesterday, 21:06

Joined

Oct 17, 2019

Messages

60

• Nov 19, 2019

• #5

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

 

Attachments

• 
  fulladdress.png

  24.5 KB · Views: 85

F

Fira_g

Registered User.

Local time

Yesterday, 21:06

Joined

Oct 17, 2019

Messages

60

• Nov 19, 2019

• #6

I see theDBguy already posted a link with solution

 

A

Access_Help

Registered User.

Local time

Yesterday, 18:06

Joined

Feb 12, 2005

Messages

136

• Nov 21, 2019

• #7

theDBguy said:

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

Click to expand...

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.

 

Attachments

• Database26.zip

  24.9 KB · Views: 86

Last edited: Nov 23, 2019

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 18:06

Joined

Oct 29, 2018

Messages

21,467

• Nov 23, 2019

• #8

Access_Help said:

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.

Click to expand...

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!

 

Attachments

• Database26.zip

  22.2 KB · Views: 83