Queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CZ - 20 Jul 2006 21:30 GMT

I have multiple fields that I want to join to one field. For instance
ID Name
1 sam
1 bill
1 charles
2 paul
2 john

I want them to look like

ID Names
1 sam; bil; charles
2 paul; john

What code do I type if the table is called "table one"?

Reply to this Message

John Vinson - 20 Jul 2006 22:46 GMT

>I have multiple fields that I want to join to one field. For instance
>ID Name
[quoted text clipped - 11 lines]
>
>What code do I type if the table is called "table one"?

Try adapting the code at

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

This function takes the tablename as a parameter, so you could just
call it passing the table name.

John W. Vinson[MVP]

Reply to this Message