Rolling up records in a database

G

Gary D

I have a list of client accounts with security positions for each client.
The problem is that if the client has more than one position the client
record is listed multiple times. I want to do a mail merge with one letter
listing all positions. How can I create a single client record listing the
multiple positions? Using Access 2003.

Thanks,
Gary
 
A

Arvin Meyer

The easiest way is to do this is to have multiple tables with one being for
clients and the other for security positions. Creat a header record (main
report) for the clients, with a subreport listing all the positions. Print
the report as a PDF or snapshot.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
G

Gary D

How would this work for a mail merge? I need to be able to print the
positions on the letter.
 
Top