How to display results of multiple queries on one report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Coolboy55
    New Member
    • Jul 2007
    • 67

    How to display results of multiple queries on one report?

    I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?

    Thanks!

    CB55
  • Coolboy55
    New Member
    • Jul 2007
    • 67

    #2
    Originally posted by Coolboy55
    I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?

    Thanks!

    CB55
    Ehh, just use subreports. Not thinking this morning...

    Comment

    • Fiddler2
      New Member
      • Mar 2008
      • 19

      #3
      Originally posted by Coolboy55
      I'm creating a report with 3 source queries. Each source query returns distinct values of the same field name (SkillID). How do I display the distinct results of all 3 queries on the same report?

      Thanks!

      CB55

      Use the "report wizard" to help you build a subset containing all three queries.

      Or, click and drag each query to a blank report in design view.

      Comment

      Working...