Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How preparing a report including a window for a subfrom containing a small list of names

Posted on 2014-11-20
5
Medium Priority
?
111 Views
Last Modified: 2014-11-26
Hi,

I am preparing a report to be printed, based on a form, This works fine.
The form contains a subform..linked to the form.  I usually prepare the report, with one line for any record of the subform. This works fine too.
But now I have a subform with only one column of short names.. And I don't want to waste one line per record on my report.. I would like these names to be set on the report like a series of continuous names, separated by something like a dot or a comma..

Thanks for any help

Jacques
0
Comment
Question by:Jacques Weissenburger
  • 2
  • 2
5 Comments
 
LVL 85
ID: 40455845
You'd have to create that in a query, and then use the query to drive that report. You can use the Concat function found here:

http://www.experts-exchange.com/Database/MS_Access/A_2380-Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html
0
 
LVL 40

Expert Comment

by:PatHartman
ID: 40456052
Or, you can set the subform to show multiple columns.  You should be able to get 4-5 columns across if you are only showing one field.
0
 

Author Comment

by:Jacques Weissenburger
ID: 40456322
Thanks Scott,  I will go through the concat function. But the document is not so easy to understand..how I can do this in a query (My report is based on 3 queries, because I have some relations that need this).   But OK,  I will take the time if I am not able to follow PatHartman proposition..

Thanks also  PatHartman : this could really be the solution.  You saw it right, I never have more then 5 records in my subform (and only one field). So, if I could make MSAccess display them in a single (an unique) row, it would be perfect..But I don't see how I can display the 1-Field records of my subform in columns and not in rows.
0
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 40457509
Here are two pictures that may help.  
Design viewReport view
0
 

Author Closing Comment

by:Jacques Weissenburger
ID: 40467979
This is just what I needed

Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question