Report for Win 7 Installs, But Only Including Specific AD Groups

[NiceGuy]

Hi,

I've been wrestling with trying to get this to work. Basically, I'm trying to get the total count of Windows 7 installs in a specific Active Directory OU tree, but also excluding one of the sub OUs within that tree.

Basically, our AD tree looks something like this

Computers_US
-California
-Florida
-Colorado
-Montana

How would I build a report that shows how many Windows 7 installs there are for all of the OUs in the Computers_US, excluding Montana, for example?

[SBSTech]

I would try:

Where tblADComputers.OU Not Like '%California%' And Not Like 'Florida' And Not Like ...etc.