Using the Join Function

  • Thread starter Thread starter mbc28ajc23
  • Start date Start date
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining Queries 1
Row Numbers In Join Query 2
fConcatChild Function help? 2
update table using a Query 3
SQL Upsizing Problem with Left Join Queries 19
Multi Value Selection issues 4
Nested query problem 6
using dlookup in a query 2

Back
Top