Access Subreport -list fields in paragraph style?

[teakwood45]

I need to make mail merge letters from my access database. I keep going back and forth between making a word mail merge or making the letter as an access report. The real problem is in a sub report. I want to list.
County Name1
City1, City2, City3..

County Name2
City1, City2, City3..

County Name3..

The county, city table is related to a main table.

How can I print fields this way? Do I use a report to make the letter or use mail merge with word?

 

[dynamictiger]

In your sub-report in Access set up a grouping on the county field, and add a group header.

In the group header put your field for county.

In the detail put a text box, which is named txtOne or some meaningless name.

In code go to onactivate and call a function to loop through the cities corresponding to the county and add them with a comma in front, except for the first instance.

I haven't got Access to Access right now, otherwise I could detail this a bit better.

HTH

 

[teakwood45]

I guess its the function I need help with. I have no idea were to start.

 

[Guest_imported]

I would very much like to know how to handle this too. I have searched high and low for a way to list multiple results in a field in a string in a report, rather than a list in a report.

That is...

You have a list of college campuses running a certain course.

You DON'T want...
Course: How to use Access
Colleges:
- Sydney
- London
- New York

You DO want...
Course: How to Use Access
Colleges:
Sydney, London, New York

Any further information would be extremely appreciated.

TCJ

 

[Guest_imported]

I am doing the same and would appreciate some feedback. I want to publish the results of a field in a report as a paragraph, rather than a list...i.e.

NOT like this...

Course: How to use Access
Colleges:
- Sydney
- London
- New York

but LIKE THIS...

Course: How to use Access
Colleges:
Sydney, London, New York

Any more advice as I did not have enough with the description for teakwood45 for progression with this issue.

TJSydney

 

[Guest_imported]

I am doing the same and would appreciate some feedback. I want to publish the results of a field in a report as a paragraph, rather than a list...i.e.

NOT like this...

Course: How to use Access
Colleges:
- Sydney
- London
- New York

but LIKE THIS...

Course: How to use Access
Colleges:
Sydney, London, New York

Any more advice as I did not have enough with the description for teakwood45 for progression with this issue.

TJSydney