A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



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

  #3  
Old June 6th, 2010, 11:02 PM 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 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/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

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.