Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Location
    Suburb of Chicago, Illinois
    Posts
    56

    Cool Unanswered: 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 suggestions are appreciated.
    Thanks,

    Krazy (Bill) Kasper

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    I'm asking a dumb question here but if you're mailing it, why not just attach a snapshot of the report into the email and then the user can't manipulate the data then?

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Paul

  4. #4
    Join Date
    Sep 2008
    Posts
    7
    I'm assuming your product data is in a separate table with a common key linking to your customer table.

    You must first establish a relationship between tables before creating the query. (See "How to Create a One-to-Many Relationship in Microsoft Access.") And use the query as the source for your mail merge.

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sub report should do the job
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Mar 2008
    Location
    Suburb of Chicago, Illinois
    Posts
    56
    Thanks everyone for your replies.

    healdem -
    I'll try using a sub-report.

    johnny773 -
    Product data is in same table.

    pBaldy -
    I'll check out the links in a bit.
    Will try sub-report first.

    grafixx01 -
    The data fields will be inbedded in a form letter to our customers.
    Specific fields such as Your [product], [serial number]
    and sincerely, [rep name]
    etc.


    Thanks again all.

    Krazy (Bill) Kasper
    Last edited by KrazyKasper; 09-30-08 at 09:42.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •