Topic
  • 1 reply
  • Latest Post - ‏2012-12-28T21:17:02Z by TSliva
TSliva
TSliva
34 Posts

Pinned topic Help with Query

‏2012-12-28T15:06:43Z |
Let me try this again as my previous post may have been confusing.

Below is the primary filter:

[Query1].[Service] in ('Lending Pipeline (Referrals)','Deposit Pipeline (Referrals)','Third Party Services (Referrals)'


Based on the above filter what I need to happen next is to NOT pull any records where:

[Query1].[Referred From] = [Query1].[Referred To] and [Query1].[Service] = 'Lending Pipeline (Referrals)' or 'Deposit Pipeline (Referrals)'


Thanks for any help.
Terry
Updated on 2014-03-25T07:43:40Z at 2014-03-25T07:43:40Z by iron-man
  • TSliva
    TSliva
    34 Posts

    Re: Help with Query

    ‏2012-12-28T21:17:02Z  
    I finally figured it out. For those who care this is my filter:

    ([Query1].[Referred to Name]  [Query1].[Referred from Name] and [Query1].[Service] in ('Deposit Pipeline (Referrals)','Lending Pipeline (Referrals)')) OR ([Query1].[Service] = 'Third Party Services (Referrals)')
    


    The part after the OR statement was necessary as I wanted all records pulled that were Third Party referrals.
    Updated on 2014-03-25T07:43:45Z at 2014-03-25T07:43:45Z by iron-man