Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advanced Lookup showing incorrect data

Accepted Solution Solved
Copper Contributor
Posts: 34
Country: United_Kingdom
Accepted Solution

Advanced Lookup showing incorrect data

[ Edited ]

I have created a lookup to show any contacts missing invoice addresses within the last 40 days.

 

eg. Create Date within last 40 days AND Invoice Contact (does not contain data) OR Invoice Address 1 (does not contain data) etc etc.

 

The query is ignoring the create date & showing all records that have invoice data missing.

 

Any suggestions please?


Accepted Solutions
Solution
Accepted by topic author beckyp
‎04-18-2017 07:07 AM
Moderator
Posts: 451
Country: United_Kingdom

Re: Advanced Lookup showing incorrect data

Hi Becky,

 

I believe the lookup should need brackets, for example

 

Create date - Within last (Days) - 40 - And

( Invoice contact - Does not contain data - or

Invoice Address 1 - does not contain data ) - End

 

 

This article goes into more detail: 26794 How to create an Advanced Query in Act!

View solution in original post


All Replies
Solution
Accepted by topic author beckyp
‎04-18-2017 07:07 AM
Moderator
Posts: 451
Country: United_Kingdom

Re: Advanced Lookup showing incorrect data

Hi Becky,

 

I believe the lookup should need brackets, for example

 

Create date - Within last (Days) - 40 - And

( Invoice contact - Does not contain data - or

Invoice Address 1 - does not contain data ) - End

 

 

This article goes into more detail: 26794 How to create an Advanced Query in Act!

Copper Contributor
Posts: 34
Country: United_Kingdom

Re: Advanced Lookup showing incorrect data

Thank you - never noticed the bracket columns!!