Expandable list in report?

  • Thread starter Thread starter JDB
  • Start date Start date
J

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
 
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."
 
Back
Top