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
|
|||
|
|||
Merge a field data for all records in a table into one output
Hi Team,
I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the output of one specific selected record. Example, I have 10 period records in a table with (Field D) that contains data but not necessarily for all of the 10 periods. I would want to print the output of any specific period record which generates the data of all the fields for that record with exception of (Field D) which I want to output its merged data that comprises the data of the selected period record plus all the data of all the previous records. In other words, if I select to output the record for period 7 then (Field D) is the only field that will contain its own merged data from record No. 1 to record No. 7 and the data needs to be merged in ascending order which is related to the sequence of the records. Is there a way to achieve this? And if so, would it be possible to apply the same to multiple Fields in the same table? I thought about doing this by applying a loop process but do not know how to capture the field data for each record one at a time to collect into one output. I hope I did not complicate the explanation. I know that there have been some great and smart solutions provided through the Forum which advises on merging data but I could not find one that is similar to my conditions. I would greatly appreciate anyone's help to solve this problem. Cheers |
#2
|
|||
|
|||
Merge a field data for all records in a table into one output
You need to concatenate one field from a group of records.
Here are links (url) to three examples using VBA. Duane Hookom http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 Allen Browne http://allenbrowne.com/func-concat.html The Access Web http://www.mvps.org/access/modules/mdl0004.htm John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Zikar wrote: Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the output of one specific selected record. Example, I have 10 period records in a table with (Field D) that contains data but not necessarily for all of the 10 periods. I would want to print the output of any specific period record which generates the data of all the fields for that record with exception of (Field D) which I want to output its merged data that comprises the data of the selected period record plus all the data of all the previous records. In other words, if I select to output the record for period 7 then (Field D) is the only field that will contain its own merged data from record No. 1 to record No. 7 and the data needs to be merged in ascending order which is related to the sequence of the records. Is there a way to achieve this? And if so, would it be possible to apply the same to multiple Fields in the same table? I thought about doing this by applying a loop process but do not know how to capture the field data for each record one at a time to collect into one output. I hope I did not complicate the explanation. I know that there have been some great and smart solutions provided through the Forum which advises on merging data but I could not find one that is similar to my conditions. I would greatly appreciate anyone's help to solve this problem. Cheers |
#3
|
|||
|
|||
Merge a field data for all records in a table into one output
Hi John
I thank you very much for having provided me with the proper guidance. The references you provided were very helpful and solved my problem completely. Also thanks to all of those who provided the examples that helped me in finding the proper solution. Cheers "John Spencer" wrote: You need to concatenate one field from a group of records. Here are links (url) to three examples using VBA. Duane Hookom http://www.rogersaccesslibrary.com/f...sts.asp?TID=16 Allen Browne http://allenbrowne.com/func-concat.html The Access Web http://www.mvps.org/access/modules/mdl0004.htm John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Zikar wrote: Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the output of one specific selected record. Example, I have 10 period records in a table with (Field D) that contains data but not necessarily for all of the 10 periods. I would want to print the output of any specific period record which generates the data of all the fields for that record with exception of (Field D) which I want to output its merged data that comprises the data of the selected period record plus all the data of all the previous records. In other words, if I select to output the record for period 7 then (Field D) is the only field that will contain its own merged data from record No. 1 to record No. 7 and the data needs to be merged in ascending order which is related to the sequence of the records. Is there a way to achieve this? And if so, would it be possible to apply the same to multiple Fields in the same table? I thought about doing this by applying a loop process but do not know how to capture the field data for each record one at a time to collect into one output. I hope I did not complicate the explanation. I know that there have been some great and smart solutions provided through the Forum which advises on merging data but I could not find one that is similar to my conditions. I would greatly appreciate anyone's help to solve this problem. Cheers . |
Thread Tools | |
Display Modes | |
|
|