Joining data from different fields into one fieled

  • Thread starter Thread starter Peter
  • Start date Start date
P

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!
 
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
 
Thanks Jeff..i will try this out..

Table A and Tale B are related by a join

Thanks again!
 
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!
Click to expand...

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