Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74

    Unanswered: A report from three different queries?

    Is it possible to create a report that will draw from three different queries. The queries will provide:

    (1) a list of all the invoices of a contract and their attributes
    (2) a list of all the contract vendors and their attributes
    (3) a list of all employees on the contract and their attributes

    Any sample/examples out there.

  2. #2
    Join Date
    Mar 2002
    Posts
    192
    Make three sub reports.. and embed all three in your main report.

  3. #3
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74
    This sounds like a very neat idea. Now the task for me is to find out how to do what you have just suggested. I have never done it.
    Do you have any clues.

  4. #4
    Join Date
    Mar 2002
    Posts
    192
    The trick is in two properties of your subform object.

    Link Master fields
    Link Child Fields

    Link the contract ID to the master field.
    Link the foreign key to ContractID to the child field.

Posting Permissions

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