Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Data on from two queries in one report

Discussion in 'Information Technology' started by lpdc, Oct 29, 2005.

  1. lpdc

    lpdc
    Expand Collapse
    Guest

    How do I use two queries in one report where on query gives a list or items
    with amounts, i.e. general ledger transactions. And the other query gives the
    total compared to budget for the entire general ledger account. Or what is
    the best solution to accomplish this?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 28 Oct 2005 13:05:33 -0700, "lpdc"
    <lpdc@discussions.microsoft.com> wrote:

    >How do I use two queries in one report where on query gives a list or items
    >with amounts, i.e. general ledger transactions. And the other query gives the
    >total compared to budget for the entire general ledger account. Or what is
    >the best solution to accomplish this?


    Probably an unbound Report with two Subreports.

    John W. Vinson[MVP]
     
  4. lpdc

    lpdc
    Expand Collapse
    Guest

    Could you give an example of how this would work or where I could go to find
    an example.

    "John Vinson" wrote:

    > On Fri, 28 Oct 2005 13:05:33 -0700, "lpdc"
    > <lpdc@discussions.microsoft.com> wrote:
    >
    > >How do I use two queries in one report where on query gives a list or items
    > >with amounts, i.e. general ledger transactions. And the other query gives the
    > >total compared to budget for the entire general ledger account. Or what is
    > >the best solution to accomplish this?

    >
    > Probably an unbound Report with two Subreports.
    >
    > John W. Vinson[MVP]
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 31 Oct 2005 12:40:09 -0800, "lpdc"
    <lpdc@discussions.microsoft.com> wrote:

    >Could you give an example of how this would work or where I could go to find
    >an example.


    None come to mind. Just try it - create a Report based on each query;
    create a new report, with no table specified; drag each of your
    specific reports from the Reports window onto the new report.

    John W. Vinson[MVP]
     

Share This Page