Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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"?
Click to expand...

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]
 
Back
Top