Community
Showing results for 
Search instead for 
Do you mean 
Reply

Trying to do a lookup by salesperson with Advanced Queries

Accepted Solution Solved
Astute Commentator
Posts: 30
Country: USA
Accepted Solution

Trying to do a lookup by salesperson with Advanced Queries

I have been using advanced queries to look up contacts for 1 specific sales person i have entered all the criteria as or and ended with salesperson but i get all the lookup results for all salespeople. what am i doing wrong


Accepted Solutions
Solution
Accepted by topic author rizzo66
‎09-25-2015 03:20 AM
Nickel Super Contributor
Posts: 843
Country: United States

Re: Trying to do a lookup by salesperson with Advanced Queries

Final or should be an and?

So, for instance: (criteria 1 or criteria 2 or criteria 3) and salesperson

Note the parens, and the and.

Rita Kogstad
RKA Associates
Stamford, CT

View solution in original post


All Replies
Solution
Accepted by topic author rizzo66
‎09-25-2015 03:20 AM
Nickel Super Contributor
Posts: 843
Country: United States

Re: Trying to do a lookup by salesperson with Advanced Queries

Final or should be an and?

So, for instance: (criteria 1 or criteria 2 or criteria 3) and salesperson

Note the parens, and the and.

Rita Kogstad
RKA Associates
Stamford, CT