By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,476 Members | 889 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,476 IT Pros & Developers. It's quick & easy.

MS Access 2003 table inside a report???

P: 11
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,
Sep 29 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,602
Are you asking how to include data from another table into your report?
Sep 29 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.