6 Replies Latest reply on Nov 14, 2012 8:58 AM by poyntzj

    Query call another query ?

    Rookie

      Hi

      I have 2 sets of queries

      The first set is used to determine what devices - Query A

           Where "computer", "Device Name" LIKE "FRED"

       

      The second set is used to determine if an application / patch needs installing - Query B

           where "computer software", "Add or remove programs", "program", "Name" = Microsoft....."

      (in this case, for Office 2010, we have 7 possible options)

       

      Is there anyway I can create a new query that would be

      If device is in Query A and Query B ?

       

      or failing that, let me copy say Query A to Query C, and then edit Query C and say take whatever the results of this query are and compare against Query B

       

      So

           Where "Computer", "Device Name" LIKE "FRED"

           and device in Query B

       

       

      As you can imagine, I do not fancy copying Query A 50 times and then adding all the lines from Query B, nor copying Query B 50 times and adding all the lines from Query A (some sites are easy - single lines, but our busier sites maybe upto 12 lines)

      Combing would make it a lot easier and quicker to deal with

       

      Many thanks