If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Joining data from different fields into one fieled
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! |
#2
|
|||
|
|||
Joining data from different fields into one fieled
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" wrote in message ... 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! |
#3
|
|||
|
|||
Joining data from different fields into one fieled
Thanks Jeff..i will try this out..
Table A and Tale B are related by a join Thanks again! "Jeff Boyce" wrote: 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" wrote in message ... 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! |
#4
|
|||
|
|||
Joining data from different fields into one fieled
On Fri, 2 Oct 2009 13:24:01 -0700, Peter
wrote: 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 -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|