Using the Join Function

M

mbc28ajc23

I want to create a query that groups by an ID in a table, and then
concatenates, using a ", " all strings in another table that share the same
ID. the on-line helps talks about a Join Function but I can't seem to use it
in this way.
 
J

John W. Vinson

I want to create a query that groups by an ID in a table, and then
concatenates, using a ", " all strings in another table that share the same
ID. the on-line helps talks about a Join Function but I can't seem to use it
in this way.
Click to expand...

That's not the function of Join. You instead need some VBA to poll through the
related table and construct a concatenated text string. See
http://www.mvps.org/access/modules/mdl0004.htm
 
Top