Concatenate Column Values from Multiple Rows into a Single Columnwith Access

#1

Subject : - Concatenate Column Values from Multiple Rows into a
Single Column with Access

I would like to combine a field's values from multiple records in a
single field. For example:

Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14

Result should look like:

Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14

#2

Vikas Chauhan wrote:

Quote:

Subject : - Concatenate Column Values from Multiple Rows into a
Single Column with Access

I would like to combine a field's values from multiple records in a
single field. For example:

Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14

Result should look like:

Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14

You might want to give Duane Hookom's generic solution a try:
http://www.rogersaccesslibrary.com/f...s_topic16.html

#3

Hi Bob,

it's not fulfill my requirements

On Jun 20, 4:41 pm, "Bob Barrows" <reb01... (AT) NOSPAMyahoo (DOT) com> wrote:

Quote:

Vikas Chauhan wrote:
Subject : - Concatenate Column Values from Multiple Rows into a
Single Column with Access

I would like to combine a field's values from multiple records in a
single field. For example:

Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14

Result should look like:

Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14

You might want to give Duane Hookom's generic solution a try:http://www.rogersaccesslibrary.com/f...on-to-concaten...

#4

That's too bad. It would be nice to know in what way it fails to meet them -
perhaps we could point out something you are missing.
In the meantime, if you copy and paste the subject line from this message
into google, perhaps you will find something that does fulfill your
requirements.

Vikas Chauhan wrote:

Quote:

Hi Bob,

it's not fulfill my requirements

On Jun 20, 4:41 pm, "Bob Barrows" <reb01... (AT) NOSPAMyahoo (DOT) com> wrote:
Vikas Chauhan wrote:
Subject : - Concatenate Column Values from Multiple Rows into a
Single Column with Access

I would like to combine a field's values from multiple records in a
single field. For example:

Last First Code
------- --------- ----
Lesand Danny 1
Lesand Danny 2
Lesand Danny 3
Benedi Eric 7
Benedi Eric 14

Result should look like:

Last First Codes
------- --------- -----
Lesand Danny 1,2,3
Benedi Eric 7,14

You might want to give Duane Hookom's generic solution a

try:http://www.rogersaccesslibrary.com/f...on-to-concaten...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Concatenate Column Values from Multiple Rows into a Single Columnwith Access

comp.databases.ms-access comp.databases.ms-access

Concatenate Column Values from Multiple Rows into a Single Columnwith Access - 06-20-2011 , 12:18 AM

Re: Concatenate Column Values from Multiple Rows into a Single Column with Access - 06-20-2011 , 06:41 AM

Re: Concatenate Column Values from Multiple Rows into a Single Columnwith Access - 06-20-2011 , 07:51 AM

Re: Concatenate Column Values from Multiple Rows into a Single Column with Access - 06-20-2011 , 07:59 AM