I have a query which is filtering on quite a bit. I need it however to filter on a little more. I need it to filter now on the Sponsor field. I need to say once all filters have taken place, out of thos records which have a sponsor address of And@hotmail.com. I need to then take this figure away from my original figure
Sum(Abs(tbl_MIS_Records.[Account Type] In ("RegularAC","TopAC") And tbl_MIS_Records.Status In ("Approved","Not Approved","Mail Sent to requestor") And (tbl_MIS_Records.Location In ("Moscow","Istanbul") Or ([Location]="Johannesburg" And [LOB]="GCCG & Rates Derivatives")))) AS First_count, -(minus)- If any of these account have a tbl_MIS_Records.[Sponsor] in ("email@example.com").