Re: Query machine with Office 2000 w/o Office 2003

Ok, so I create a query that returns the names of the PC's with Office 2003.
And when I try to do a NOT IN subselect group, and select my first query, I
get an error stating "please enter a valid subslect statement."

Any ideas? here is my original query.

select SMS_R_System.Name from SMS_R_System inner join
SMS_G_System_ADD_REMOVE_PROGRAMS on
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office
Professional Edition 2003" order by SMS_R_System.Name



"Kim Oppalfens" <Kim dot Oppalfens@google mail.com> wrote in message
news:OL$5xVN2FHA.1100@xxxxxxxxxxxxxxxxxxxxxxx
> Another typical "not in" query.
>
> You basicly first create a query for all machines that have office 2003
> installed.
> You then create a query for all machines that office 2000 but are "not in"
> the result set of the first query.
>
> The following articles explains this quite nicely, if you can't make it
> work than just post back here.
> http://myitforum.techtarget.com/articles/1/view.asp?id=179
>
> --
> Kim Oppalfens
> Telindus Belgium
> MVP Windows Server System - SMS
> "Bryan McDaniel" <bmcdaniel@xxxxxxxxxxx> wrote in message
> news:uAMPWoK2FHA.820@xxxxxxxxxxxxxxxxxxxxxxx
>>I am trying to create a query that will tell me which machines have Office
>>2000 installed and NOT Office 2003. Reason being is we have one
>>application that requires Excel 2000. So if I create a collection based
>>on a query that has Office 2000 installed, it sees Excel 2000 and thinks
>>that it need to install office 2003, when in fact, it may already have
>>2003, and excel 2000. My current query is based on add/remove
>>programs....If Add/remove includes;Office 2000.....and NOT add/remove
>>Office 2003.....But I am still getting all machines as if I have not
>>included the not statement....
>>
>> Please advise
>>
>
>


.

Relevant Pages

  • Re: Using Excel in VB6
    ... Not sure where the database drivers come in to get to Excel, ... might be something that comes when you install Access. ... the "Create Query In Design View", ... From there you right click in the Query Designer ...
    (microsoft.public.vb.general.discussion)
  • Re: Query Help: How can I get X but with out Y?
    ... Create a collection with all machines you ... Create a query that querries for all machines that have installed ... > package and the advertisement and pushed the install out with success. ...
    (microsoft.public.sms.admin)
  • Re: Using Excel in VB6
    ... This is also very portable and does not require an app on ... And I'm almost positive that you can export Excel to XML... ... might be something that comes when you install Access. ... the "Create Query In Design View", ...
    (microsoft.public.vb.general.discussion)
  • RE: Problem creating query with exe files of different versions
    ... Try using a subselect query to include systems that have version less than ... > I am upgrading an application x on machines across network. ... > trying to install is 9 ... > Now the problem is that for few machines my software inventory has ...
    (microsoft.public.sms.swdist)
  • Re: Access Query to Predefined Excel Spreadsheet
    ... >From Excel Select range where you want to put the data, ... External Data/Create New Query and follow the prompts. ... You may need to install MS Query ...
    (microsoft.public.access.externaldata)
Loading