Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10579

Re: Concatenate Thru Join Table (?)

Show all headers | View raw

On 06/04/2015 20:03:24, croy wrote:
> Three tables, one is a joiner.
> 
> tblx
> tblxId
> 
> tblJoin
> tblxId
> tblzId
> 
> tblz
> tblzId
> ItemName
> 
> Goal:  a query that outputs one row for each tblxId and
> tblyId combination, and concatenates the ItemName(s),
> separated by commas (if there are more than one).  I've been
> trying to go off of Hookum's simpler example, but just can't
> seem to get it working.  As soon as I pull tblJoin into the
> query, I get multiple rows for each tblx record.
> 
Firstly, I think your question is wrong as I assume there is only one
ItemName for each TblZID Therefor I think you want a row for each TblXID and
it's corresponding concatenated ItemNames. To the best of my knowledge, this
can only be done using VBA to read the table and add a comma space after each
ItemName.  At the end of the loop remove the final comma space

Phil

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Concatenate Thru Join Table (?) croy <croy@invalid.net> - 2015-04-06 12:03 -0700
  Re: Concatenate Thru Join Table (?) "Phil" <phil@stantonfamily.co.uk> - 2015-04-06 22:04 +0100
  Re: Concatenate Thru Join Table (?) Cindy Krist <cindy@smbpartners.com> - 2015-04-07 06:49 -0700
    Re: Concatenate Thru Join Table (?) croy <croy@invalid.net> - 2015-04-08 06:10 -0700
      Re: Concatenate Thru Join Table (?) "Phil" <phil@stantonfamily.co.uk> - 2015-04-08 18:21 +0100
  Re: Concatenate Thru Join Table (?) "Phil" <phil@stantonfamily.co.uk> - 2015-04-07 14:54 +0100

csiph-web