Raymond Posted June 13, 2018 Share Posted June 13, 2018 Hey guys, I'm trying to isolate my door objects that have the number "1" for its ID Label value. However inputting this into the criteria window identifies objects that have 0, 1, 2, and 3 for their ID Label values. What am I doing wrong? Thanks, Raymond Quote Link to comment
0 michaelk Posted June 13, 2018 Share Posted June 13, 2018 Raymond The worksheet criteria manager doesn't have a way to distinguish between (this criterion) AND (that criterion) and (this criterion) OR (that criterion) To fix it you have to get under the hood. From the screen you have pictured, hit Cancel. In the formula bar you will see the "scripted" version of the database criteria. Change all the bars (|) to ampersands (&). This will limit the objects in the database to those that meet ALL the criteria, not just one criterion. 2 Quote Link to comment
0 Raymond Posted June 13, 2018 Author Share Posted June 13, 2018 @michaelk That worked perfectly, Thanks for your help Michael. Quote Link to comment
Question
Raymond
Hey guys, I'm trying to isolate my door objects that have the number "1" for its ID Label value.
However inputting this into the criteria window identifies objects that have 0, 1, 2, and 3 for their ID Label values.
What am I doing wrong?
Thanks,
Raymond
Link to comment
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.