View Single Post
  #2  
Old June 3rd, 2010, 01:31 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default 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