Expandable list in report?

[JDB]

I want to generate a report (letters) from a query. The query lists 100
unique sites and their corresponding state representative.

I want the report to be a letter to each state rep (so grouped by state
rep). In the body would be a listing of the sites in their district. Some
reps have 1 site, some have as many as 10.

In simplified form, I'd like the letter to look like this -


Dear Representative Burns,

We wanted you to know the following sites are in your district:

Site 1
Site 2
Site 3 (list is a different size for each rep)

Sincerely,

Homer J. Simpson


I know how to do the letters, I don't know how to create the expandable
list. Any help is greatly appreciated. Thanks

 

[Al Campagna]

JDB,
You should have a table for Reps (the ONE) and a table
of Sites within that Rep's district (the MANY)... related by some key value
like a
DistrictID.
You main report should be based on the Rep table, with a subreport based
on
the Sites table. As a subreport, it would grow/shrink according to the
number of
sites.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Duane Hookom]

Consider creating a single expression with all the sites using the generic
concatenate function found at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16. I use this
to create a Word Merge file. The concatenate results can include a carriage
return if needed.