Prev: Printing a report 2-up
Next: Need Specific Data
From: Zikar on 3 Jun 2010 03:07
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
From: John Spencer on 3 Jun 2010 08:31
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/forum/forum_posts.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
From: Zikar on 6 Jun 2010 18:02
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/forum/forum_posts.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
> .
>
 | 
Pages: 1
Prev: Printing a report 2-up
Next: Need Specific Data