Query / Report - Combine Names into one report

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

Patrick Graham

I have a Clients Table and an Investment Proposal Table.
2 clients at most (usually) are link to the same
Investment Proposal.

I want to print a one page report that will list both the
clients names, but only show the other information once.

How can I combine the 2 Clients Names into one section of
the report I.e.

<--report top of page ---->
Client Name(s):
ClientName1
ClientName2

Bunch of IPS Specific Information
<--report ends---->
 
Patrick,

This is best done within the design of the report, rather than in a
query. The basic concept would be that you use the report's Sorting
and Grouping facility to create a Grouping on the field that links the
two tables, presumably this would be the primary key of the Investment
Proposal table, and make a group footer on this field. Then, the
Client Names would be placed in the Detail section of the report, and
the IPS-specific information goes in the group footer.

- Steve Schapel, Microsoft Access MVP
 
Back
Top