Need help with query!

[drenalin]

Hi,

I'm having trouble pulling the records I need.

Below is my primary filter:

Code Select Expand


[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:

Code Select Expand


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


Thanks for any help.
Terry

[blom0344]

[Query1].[Referred From] <> [Query1].[Referred To] and [Query1].[Service] not in ('Lending Pipeline (Referrals)','Deposit Pipeline (Referrals)')