Joining data from different fields into one fieled

[Peter]

How do I display data from three different fields in a table to one filed in
a form. This because I want to copy the “joined data string†and paste it in
an email …

Table A. Filed apples. Field oranges
Table B. Filed Bag

Result in one filed in a form should be: Apples / Oranges / Bag

Is this possible?

Thanks for all help and suggestions!

 

[Jeff Boyce]

Peter

Use a query and concatenate them...

By the way, unless you have a common field between your TableA and TableB,
how will you know which record in TableB belongs with which record in
TableA?

Regards

Jeff Boyce
Microsoft Access MVP

 

[Peter]

Thanks Jeff..i will try this out..

Table A and Tale B are related by a join

Thanks again!

 

[John W. Vinson]

How do I display data from three different fields in a table to one filed in
a form. This because I want to copy the “joined data string” and paste it in
an email …

Table A. Filed apples. Field oranges
Table B. Filed Bag

Result in one filed in a form should be: Apples / Oranges / Bag

Is this possible?

Thanks for all help and suggestions!

Try the code at http://www.mvps.org/access/modules/mdl0004.htm