View Single Post
  #1  
Old June 3rd, 2010, 08:07 AM posted to microsoft.public.access.reports
Zikar
external usenet poster
 
Posts: 11
Default 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