×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Query dilema/need suggestions

Query dilema/need suggestions

Query dilema/need suggestions

(OP)
I am developing a query that looks for the following criteria:

1). looks for the presence of an environment variable, in this case "bmhcc_stdver"

2). excludes all pc's that have another environment variable, in this case bmhcc_stdver !="3.2"

3). then the last step of the query, I want all of the pc's that fit the above two criteria AND do not have the file hf022498.pwr.

The problem I get is that it returns me every file in the database that is not hf022498.pwr...... on each machine that met the first 2 criteria.

Any ideas?

RE: Query dilema/need suggestions

(OP)
I received the answer to this dilema from Dave Yarbrough. The correct way
to do this is via subselect query. Here is how you do it
1). Create a query that finds all system names that HAVE the file in
question. Name it something like HAS pet.xls
2). Create a second query. Use criterion type of "subselected values".
THIS IS THE IMPORTANT PART... USE SYSTEM NAME "not in" Browse to your
query you created in step one. Name it something like W/O pet.xls

It makes perfect sense after I had it handed to me. I returned the system
name with the first query, so I want to find out all the system names that
do not have the file. In my situation, I had
other criteria to meet before this query was complete. I created another
criteria that met the other two criteria and created a collection with
that query. I then used this collection to limit the workstation
population. One important reminder is to use the same limiting collection
when creating your final collection that you used in your final query. For
some goofy reaason, the collection in your query is not retained.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close