MS Access 2003 – table inside a report
I have an Access report that I use in a mail merge (export to Excel and then mail-merge into a Word document). The report currently shows:
CustomerId
CustomerName
SaleRepName
ContractNumber
ContractDate
I need to include data that shows the products and their respective serial numbers owned by the customer. A customer can have multiple products. For example:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial #:AB800 123456789, AB800 987654321, ZZ450 457052997
Alternatively, if I can pull the Model/Serial data into Word as a table it could be something like:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial:AB800 123456789
Model/Serial: AB800 987654321
Model/Serial: ZZ450 457052997
All help is appreciated.
Thanks,
I have an Access report that I use in a mail merge (export to Excel and then mail-merge into a Word document). The report currently shows:
CustomerId
CustomerName
SaleRepName
ContractNumber
ContractDate
I need to include data that shows the products and their respective serial numbers owned by the customer. A customer can have multiple products. For example:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial #:AB800 123456789, AB800 987654321, ZZ450 457052997
Alternatively, if I can pull the Model/Serial data into Word as a table it could be something like:
CustomerId: 123456
Customer Name: ABC Corporation
Sales Rep: Joe Smith
Contract #: 200-1234567-000
Contract Date: 07/01/2007
Model/Serial:AB800 123456789
Model/Serial: AB800 987654321
Model/Serial: ZZ450 457052997
All help is appreciated.
Thanks,
Comment