Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Query - Equal To operator still brings up incorrect data

New Member
Posts: 5
Country: Australia

Advanced Query - Equal To operator still brings up incorrect data

[ Edited ]

I am trying to run a query as follows:

 

Equal to = consultant1 or

Equal to = consultant2 or

Equal to = consultant3 and

Equal to = client and

Equal to = B

 

I keep getting various results in the "client" field and require 'client' only??? Why would this be?

Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Advanced Query - Equal To operator still brings up incorrect data

You don't indicate that you grouped the OR statements.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 5
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

I have just checked an no I haven't grouped the OR statements. If I place a parenthesis around all consultants, the query still generates a list of 200 results with mixed ratings ie. 'client', 'personal', 'deceased' etc. 

Bronze Contributor
Posts: 955
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

I would try

 

(Equal to = client and Equal to = B) and

(Equal to = consultant1 or Equal to = consultant2 or Equal to = consultant3)

 

It really is about getting the brackets in the right order

 

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
New Member
Posts: 5
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

I must be missing something as I can not filter "Clients" only when using 'equal to=' ?? 

New Member
Posts: 5
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

OK will try this now. Thanks

New Member
Posts: 5
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

Yes it's all about the bracket order. Thanks for getting me back on track. 

Bronze Contributor
Posts: 955
Country: Australia

Re: Advanced Query - Equal To operator still brings up incorrect data

So did that now work for you love to know that it did

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.