98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access 2003 training - Sub reports
microsoft access 2003 training - Sub reports
Resolved · Low Priority · Version Standard
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
Tue 25 Sep 2007, 10:36Trainer David said...
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
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
Mon 15 Oct 2007, 17:09
Edited on Mon 15 Oct 2007, 17:10Trainer Richard said...
RE: Sub reports
not sure if this is possible, will keep on asking around.
Carlos, do you have any ideas
Wed 17 Oct 2007, 09:33Trainer Carlos said...
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
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
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. |
Access tip:Insert The Current DateTo insert the current date into a Table field or Form Text box use: |
