To see who has not installed Orifice 2007 and also not installed the compatability pack:
Compute.Software.Application Suites. Application Suite. Name <> Microsoft Office Professional 2007 (or whatever version you have)
AND Compute.Software.Application Suites. Application Suite. Name <> Compatability Pack for the 2007 Office system
Sometimes it is easier to App Suites, sometimes not.
Well, part of the high volume output was Friday afternoon doldrums
I had unqualified version selected for the column listing which put out all the extraneous data. (yes, duh.) That solved, it usually appears that the application suite method works, but in cross-checking (as I was doing before posting this), I still get errors on checking for existence of specific files within the package (most specifically, moc.exe or others within the compatibility packand which are confirmed to be present), but don't query out properly--thus the mistrust.
What I've done that seems to work is:
computer.software.application suites.application suite.name <> Compatibility Pack for the 2007 Office System
AND (computer.software.package.file name = winword.exe AND computer.software.package.version < 12)
This confirms that the compatibility pack is not present AND Office IS installed, but not 2007.
So, I still have the question why a query against a specific file that I've confirmed does exist isn't successful.
When attempting to use the version field you have to be careful. It is a string field, so if you say something is <12, it will do a string compare. For example, version 8 is greater than version 12, also version 100 is less than version 12.
Managed Planet's Executive Report Pack has a reporting feature that allows you to work around this issue, by expliciting telling which versions are less than others.