Rolling up records in a database

[Guest]

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

 

[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

 

[Guest]

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

 

[Arvin Meyer]

You can use code in Word to create a table from a recordset that you've
created in Access. There is some sample code in Ken Get's VBA Developer's
Handbook:

http://www.amazon.com/exec/obidos/ASIN/0782129781/ref=ase_mcwtechnologies
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access