473,406 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > how to consolidate multiple records from a subform onto 1 line in a report

Join Bytes to post your question to a community of 473,406 software developers and data experts.

How to consolidate multiple records from a subform onto 1 line in a report

Hi,

I have a form A that contains a subform B listing the names of potentially multiple people all associated with the 1 record displayed on form A. That part works just fine.

Now, I want to be able to create ONE line (NOT just a subreport listing all the names from the subform) in my associated report that basically loops through all the records, pulls out all the names associated with that one record, and lists them separated by commas.
(ie. Names: Joe, Fred, David, etc).

Can this be done using Open.Recordset and searching through the records? And, if so, how exactly would you go about doing it? For some reason, I always have problems using Open.Recordset...
May 25 '11 #1

✓ answered by NeoPa

Check out Combining Rows-Opposite of Union.

3 2240
NeoPa
32,556 Expert Mod 16PB
Check out Combining Rows-Opposite of Union.
May 25 '11 #2
Works wonderfully. Thanks for the suggestion.
May 26 '11 #3
NeoPa
32,556 Expert Mod 16PB
A pleasure Lori. Welcome to Bytes!
May 26 '11 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
consolidate multiple records
by: Andrew Chanter | last post by:
I have a table containing multiple records per key. eg: 1 | John Smith 1 | Mary Brown 1 | Julie Grey 2 | Danny Pink 2 | Jill White I need to consolidate this into a single record for each...
Microsoft SQL Server
6
Adding multiple records to a subform using VB
by: Wendy Powley | last post by:
I have a subform which represents a 1:N relationship with the main form. I would like to be able to read values from an external file, fill the subform with the values read & allow the user to...
Microsoft Access / VBA
3
reports/ can we alternate no shading and then shading for multiple records such as a phone directory to help distinguish
by: buck | last post by:
reports/ can we alternate formatting such as "no shading" and then "shading" for multiple records such as a phone directory in Access2000 reports
Microsoft Access / VBA
0
how to display multiple lines in one crystal report chart
by: michael | last post by:
Hi all, i want to know how to display multiple lines in one crystal report chart in asp.net i wrote some codes but it always display 2 lines in separate chart(please refer to the codes...
ASP.NET
12
insert multiple records
by: shank | last post by:
I'm trying to use online samples for submitting multiple records from ASP into a stored procedure. Failing! Through the below form, a user could be submitting many records at a time. I'm not...
ASP / Active Server Pages
5
Conditional test to combine multiple records
by: jhutchings | last post by:
Hello everyone, I have a database where I collect shipment data from various tables. However, I have a problem. Whenever I want to see shipping data for orders that were set to ship on or before...
Microsoft Access / VBA
5
copy and paste multiple records
by: Kaur | last post by:
Hi, I have been successful copying a vba code from one of your posts on how to copy and paste a record by declaring the desired fields that needs to be copied in form's declaration and creating two...
Microsoft Access / VBA
1
Problem displaying multiple records in one form for data entry.
by: NumberCruncher | last post by:
Hi All, I am struggling with setting up my first system of tables, forms,and reports, and could use your help! I am setting up a database to keep track of the production of a produced item. The...
Microsoft Access / VBA
2
Printing multiple records on one line
by: HansyW | last post by:
Please help I m reading data and need to output to a file. For each record, I have a header and several details records. I need the header to be on one line, all the details on another line , and...
Visual Basic 4 / 5 / 6
4
one column text with multiple records to multiple data coulumns
by: ME2007 | last post by:
Can anyone help me to write a t-sql script to import a txt file to sql server 2000? I received a text report from a vendor that i need to extract the data for calculations. Each patient account has...
Microsoft SQL Server
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!