Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Ohio, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting report data from multiple queries

    I need to be able to include data in a report that is drawn from multiple queries and cannot seem to get this to work. Is it possible? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Running Access97.

    Thanks
    Pat Russell
    Process Automation Engineer

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting report data from multiple queries

    Yup. Post back with some details about what you're trying to accomplish and some info about the data and the queries.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Getting report data from multiple queries

    Entirely possible through the use of subreports. Each subreport is bound to its own separate record source but linked to the parent report the same way that subforms are linked to parent forms.
    Charlotte

  4. #4
    Lounger
    Join Date
    Feb 2001
    Location
    Ohio, USA
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting report data from multiple queries

    Thanks...that worked great! <img src=/S/groovin.gif border=0 alt=groovin width=21 height=21>
    Pat Russell
    Process Automation Engineer

Posting Permissions

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