RE: Not in Add/remove programs

Tech-Archive recommends: Fix windows errors by optimizing your registry

Subselect queries will be your new best friend:

http://www.myitforum.com/articles/1/view.asp?id=179
--
Standarize. Simplify. Automate.


"JanLisbjerg" wrote:

Hi

I would like to make a query that lists all the PC's in a collection, that
does not have Trend Micro installed.
How can I do that ?

If I try to make a query that lists all the PC's where add/remove display
name is not like Trend Micro% it just lists all PC's - because all PC's have
some other programs installed.
.

Relevant Pages

  • RE: Weird Problem with a Subreport
    ... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... Now I need to make reports for the lists for all ... a save as for the reports and just change which query they are getting the ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header? ...
    (microsoft.public.access.reports)
  • RE: Weird Problem with a Subreport
    ... Do you have a table that lists all the tests for the year by month? ... you could filter your query by the month identifier. ... and used sorting and grouping to sort by the placeholder and all is well!!!! ... Do you have a text box in the Goup Header? ...
    (microsoft.public.access.reports)
  • Re: Question on joins
    ... single-table FROM clauses and infixed notation in all my multi-table ... Both my first step (attempting to find the join conditions in the ugly ... comma-seperated query) and your show clearly ... and WHERE clause lists to take advantage of the Law of Proximity in my ...
    (microsoft.public.sqlserver.programming)
  • RE: Weird Problem with a Subreport
    ... Ok for the sorting i will try to explain it to you. ... query by writing the SQL I didnt include the Place holder field, ... Do you have a text box in the Goup Header? ... I have a header of shutdown in front of the whole list but the two lists ...
    (microsoft.public.access.reports)