Community
Showing results for 
Search instead for 
Do you mean 
Reply

Need help creating an advanced query

Accepted Solution Solved
Copper Contributor
Posts: 51
Country: Canada
Accepted Solution

Need help creating an advanced query

Hi everyone,

 

I'm having trouble created an advanced query. I'm trying to create an advanced query that I can use as my email subscriber list. However, instead of including all my email subscribers and excluding all the AEM opt outs and bounces, the lookup seems to include everyone in the database. How do I correct this? I have updated my email campaign history. 

 

Thanks,

 

T

AQ.PNG

 

  • Act! Premium Version 18.1
  • Microsoft Office Version: 1705
  • Shared Database
  • Windows 7

 


Accepted Solutions
Solution
Accepted by topic author TinaA
3 weeks ago
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Need help creating an advanced query

Two main flaws, you need to group the opt outs and bounce backs with parenthesis and using all ORs means you will likely select all contact in the database.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author TinaA
3 weeks ago
Platinum Elite Contributor
Posts: 6,668
Country: USA

Re: Need help creating an advanced query

Two main flaws, you need to group the opt outs and bounce backs with parenthesis and using all ORs means you will likely select all contact in the database.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129