Combining multiple returns of same field.

's Computer Specifications

I have the following table...
Field1 Field2
A 1
A 2
B 5
B 8
How do I produce the following result?
A 1, 2
B 5, 8

's Computer Specifications

See http://www.mvps.org/access/modules/mdl0008.htm

--
Joan Wild
Microsoft Access MVP

gac wrote:
> I have the following table...
> Field1 Field2
> A 1
> A 2
> B 5
> B 8
> How do I produce the following result?
> A 1, 2
> B 5, 8

's Computer Specifications

Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"gac" <(E-Mail Removed)> wrote in message
news:23537C77-0153-432A-B336-(E-Mail Removed)...
>I have the following table...
> Field1 Field2
> A 1
> A 2
> B 5
> B 8
> How do I produce the following result?
> A 1, 2
> B 5, 8

's Computer Specifications

On Mon, 6 Nov 2006 10:57:02 -0800, gac <(E-Mail Removed)>
wrote:

>I have the following table...
>Field1 Field2
>A 1
>A 2
>B 5
>B 8
>How do I produce the following result?
>A 1, 2
>B 5, 8

See the sample code at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: combining multiple field in 1 column	Tom Wickerath	Microsoft Access	0	12th Jan 2010 08:25 AM
Combining multiple fields into one field (list).	=?Utf-8?B?aGNkdzI5?=	Microsoft Access Queries	3	2nd Dec 2005 07:41 PM
Combining multiple columns into one row in one field	Will	Microsoft Access Queries	3	15th Aug 2005 01:10 PM
Re: Combining a field in multiple records into a single memo field	Andrew Smith	Microsoft Access Queries	0	25th Feb 2004 08:45 PM
Re: multiple field returns	Peo Sjoblom	Microsoft Excel Worksheet Functions	0	17th Sep 2003 02:00 PM