Combine records

[jdawg_1989]

Hi All,

I am after some help with a query. I curruntly have some data which is displayed as the following:

Record: Name: Name:
2 Bob
2 Bob June
2 Karen
2 Frank

I have lots of data which is like this and would like to run a query to get the information as follows:

Record: Name1: Name2: Name3: Name4:
2 Bob June Karen Frank

I've messed about with a Crosstab but have had no luck, any guidance or solutions would be much appreciated.

Thanks in advance.

 

[Beetle]

Have a look at the following link. There is an example database with a function that will allow you to concatenate child records into a single field. You call the function in a query. If you have any questions about the example, post back.

http://www.rogersaccesslibrary.com/forum/generic-function-to-concatenate-child-records_topic16.html

 

[jdawg_1989]

Thanks V Much for the link,
I tried it out and was getting a few problems, but found something else.

I manage to solve my problem with the following method:
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/1479/concatenate-records
The posy by "Sidney Linkers" did it for me!