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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have set up a query that populate

Status
Not open for further replies.

MarkR800

Technical User
Jan 31, 2003
20
0
0
GB
I have set up a query that populates a collection based upon the site where the client computers are based.

The query SHOULD exclude all computers that are based at a specific site, by ignoring any computer that has that specific site as either its 'Installed' or 'Assigned' site (or both).

However, I am still finding that computers with this 'excluded' site are ending up in the collection.

Does anyone have any ideas how to get around this?
 
Thanks for that, Rod. It seems to work fine in out test environment, I will try it for real as soon as I can.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top