Merge a field data for all records in a table into one output

Z

Zikar

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
 
Z

Zikar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top