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
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
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
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
