Combine like rows

Bryon · Mar 1, 2005

I'm trying to combine like rows for example:

Field 1 Field 2
DOG James
DOG Bart
DOG Jason
CAT Williams

I'm trying to get the end result to look like:
Field 1 Field 2
DOG James Bart Jason
CAT Williams

Thanks all!

John Vinson · Mar 1, 2005

I'm trying to combine like rows for example:

Field 1 Field 2
DOG James
DOG Bart
DOG Jason
CAT Williams

I'm trying to get the end result to look like:
Field 1 Field 2
DOG James Bart Jason
CAT Williams

Thanks all!

You can adapt the VBA code at

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

John W. Vinson[MVP]

Bryon · Mar 1, 2005

I need it to be a query

-Bryon

John Vinson said:
You can adapt the VBA code at

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

John W. Vinson[MVP]

John Vinson · Mar 1, 2005

I need it to be a query

Sorry. Can't be done, not with an arbitrary number of records.

You can call the VBA function from a query.

John W. Vinson[MVP]