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 |
Thread Tools | |
Display Modes | |
|
|