MS Access 2003 – table inside a report???

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KrazyKasper
    New Member
    • Mar 2008
    • 11

    MS Access 2003 – table inside a report???

    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,
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32656

    #2
    Are you asking how to include data from another table into your report?

    Comment

    Working...