Combine like rows

[Guest]

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]

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]

 

[Guest]

I need it to be a query

-Bryon

You can adapt the VBA code at

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


John W. Vinson[MVP]

 

[John Vinson]

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]