Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2003 training - Sub reports
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access 2003 training - Sub reports
Resolved · Low Priority · Version Standard
Reply Tue 25 Sep 2007, 09:36Delegate Stewart said...
Stewart has attended:
Access Intermediate course
Sub reports
Can I deliver results in a text string ( ie divided by commas and wrapping round in the output space) rather than in a column.
ie Result1, Result2, Result3 ...
Not
Result1
Result2
Result3
Stewart
For upcoming training course dates see: Pricing & availability
RE: Sub reports
Hi Stewart
If you go into Design view within Microsoft Access Reports, you should be able to move each field arround to exactly where you want it to be.
I hope this solves your Microsoft Access Report problem
David
Reply Tue 25 Sep 2007, 13:59Delegate Stewart said...
RE: Sub reports
I should be more precise.
I have a file of "Teams" containing Teamname and I have a file of "People" who link to "Teams".
In a subreport, I am able to do:
Teamname: Chester
Eric Williams
Bill Price
John Elliott
David Benham
What I want to do is:
Teamname: Chester
Eric Williams, Bill Price, John Elliott, David Benham
Is this possible? How do I do it?
Thanking you in advance,
Stewart Smith
RE: Sub reports
not sure if this is possible, will keep on asking around.
Carlos, do you have any ideas
RE: Sub reports
When you create a report in Access the lists will always come out as shown above.
To have the lists appearing as Stewart requires could probably be done with some VBA coding to reorganize the text in the report.
Carlos
Reply Mon 22 Oct 2007, 21:18Delegate Jon said...
RE: Sub reports
Hi Stewart,
In the 'Control Source' of a Report Text Box Properties insert the following, where "FieldName 1,2,3" etc are the fields you want to line up.
=[Fieldname1] & ", " & [FieldName2] & ", " & [FieldName3] & ", etc..."
The commas are optional!
Cheers
Reply Thu 25 Oct 2007, 10:10Delegate Stewart said...
RE: Sub reports
Thanks for the reply but the fields are all "TMname" in different records in the "Teammembers" file.
I'm sure it can be done with some tricky VBa - I guess I need to set myself the task of learning it.
Stewart Smith
|