R
RoadKyng
I have several form letters I have converted into Access reports. The form
letter has a CorpName as a group header followed by the address info. I then
added a subform that pulls names of the addressee based on their relationship
to our Company (e.g. Customer Rep, facility manager). The detail portion of
the report has my boilerplate language, with a few controls interspersed to
provide values.
My problem is I get mutiple pages of detail when more than one addressee is
in the subform. The first page is correct. (e.g. if there are three names in
the subform, all three names print followed by the detail) After that I'll
get two more pages of detail with no address data.
I know what is happening - the report is printing a detail for each of the
name values found. I just don't know how to restrict it. In queries we can
set them to return unique values or records. I need the same type
functionality here.
Any Ideas?
letter has a CorpName as a group header followed by the address info. I then
added a subform that pulls names of the addressee based on their relationship
to our Company (e.g. Customer Rep, facility manager). The detail portion of
the report has my boilerplate language, with a few controls interspersed to
provide values.
My problem is I get mutiple pages of detail when more than one addressee is
in the subform. The first page is correct. (e.g. if there are three names in
the subform, all three names print followed by the detail) After that I'll
get two more pages of detail with no address data.
I know what is happening - the report is printing a detail for each of the
name values found. I just don't know how to restrict it. In queries we can
set them to return unique values or records. I need the same type
functionality here.
Any Ideas?