Concatentating a COLUMN

[cawillwe]

I have records that have children in another table and I would like to be able to concatenate the string in one field in a query:

Table A:
tblA_ID
FieldA1
FieldA2

Table B:
tblB_ID
tblA_ID
FieldB1

Now say I have in Table A:
tblA_ID FieldA1 FieldA2
1 abcd efgh

and in Table B:
tblB_ID tblA_ID FieldB1
1 1 ghghghg
2 1 popopop

and in a query or form or whatever I want to show:
tblA_ID FieldA1 FieldA2 FieldB1*
1 abcd efgh ghghghg,popopop

Any ideas?

 

[jstutz]

See my reply in General group...