Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I run a query that also excludes machines from another query ?

Status
Not open for further replies.
Feb 18, 2002
30
GB
I have written a query that displays machines with a particular version of Internet Explorer and displays its version number. I have noticed I have some of the same machines appearing in both a query for IE 5.5 and IE 6.0.
I think these are the machines that were upgraded to IE 6.0 and still, technically, have IE 5.5 installed as well (if one decides to un-install and return to the previous version).

I need to run a new query that will display the results for IE 5.5 but excludes machines that also appear in the IE 6.0 query (I have also created collections on these queries as well).

Any ideas how to do this ?
 
If you use "Subselected Values" in the criterion type of the criteria setup window you can select a query and use "is in" or "Is not in" as an operator.

Ive found that it's best to keep the original query as simple as possible.

hope this helps :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top