Ok, I went ahead and just stuck the criteria in to my SQL as I was having issues with linking the table to my imported DB tables. It's working. However, I've run in to an error when having two sets of criteria left. I suspect I've done too many nested statements. Any suggestions for a work around? I need to add two more IIFs. Many thanks.

SELECT Gift.Gf_Constit_Code AS Constituency, Gift.Gf_Amount AS GiftAmount, GfFnds_1.GfFnds_1_Amount AS SplitAmount, CFSFundCode.GfFnds_1FnAtrCat_1_Description AS FundCode, IIf([fundcode]='440' And [Constituency] Like "*Alumni*" Or "*Other Individual*",'450070',0) AS PSAccount, IIF([FundCode]="460" OR [FundCode]="610" OR [FundCode]="620" AND ([Constituency]="Alumni"),'450440',

IIF([FundCode]="460" OR [FundCode]="610" OR [FundCode]="620" AND ([Constituency]="Parent" OR [Constituency]="Staff" OR [Constituency]="Student" OR [Constituency]="Other Individual"),'450430',

IIF([FundCode]="460" OR [FundCode]="610" OR [FundCode]="620" AND ([Constituency]="Foundation"),'450420',

IIF([FundCode]="460" OR [FundCode]="610" OR [FundCode]="620" AND ([Constituency]="Corporation"),'450410',

IIF([FundCode]="460" OR [FundCode]="610" OR [FundCode]="620" AND ([Constituency]="Fund-Raising Organization" OR [Constituency]="Religious Organization" OR [Constituency]="Other Organization"),'450450',

IIF([FundCode]="810" OR [FundCode]="815" OR [FundCode]="820" OR [FundCode]="870" OR [FundCode]="873" OR [FundCode]="874" OR [FundCode]="875" OR [FundCode]="877" OR [FundCode]="890" OR [FundCode]="910" AND ([Constituency]="Alumni"),'450330',

IIF([FundCode]="810" OR [FundCode]="815" OR [FundCode]="820" OR [FundCode]="870" OR [FundCode]="873" OR [FundCode]="874" OR [FundCode]="875" OR [FundCode]="877" OR [FundCode]="890" OR [FundCode]="910" AND ([Constituency]="Parent" Or [Constituency]="Staff" Or [Constituency]="Student" Or [Constituency]="Other Individual"),'450330',

IIF([FundCode]="810" OR [FundCode]="815" OR [FundCode]="820" OR [FundCode]="870" OR [FundCode]="873" OR [FundCode]="874" OR [FundCode]="875" OR [FundCode]="877" OR [FundCode]="890" OR [FundCode]="910" AND ([Constituency]="Foundation"),'450320',

IIF([FundCode]="810" OR [FundCode]="815" OR [FundCode]="820" OR [FundCode]="870" OR [FundCode]="873" OR [FundCode]="874" OR [FundCode]="875" OR [FundCode]="877" OR [FundCode]="890" OR [FundCode]="910" AND ([Constituency]="Corporation"),'450310',

IIF([FundCode]="810" OR [FundCode]="815" OR [FundCode]="820" OR [FundCode]="870" OR [FundCode]="873" OR [FundCode]="874" OR [FundCode]="875" OR [FundCode]="877" OR [FundCode]="890" OR [FundCode]="910" AND ([Constituency]="Fund-Raising Organization" OR [Constituency]="Religious Organization" OR [Constituency]="Other Organization"),'450350',

IIF([FundCode]="120" OR [FundCode]="130" OR [FundCode]="210" OR [FundCode]="220" OR [FundCode]="230" OR [FundCode]="233" OR [FundCode]="235" OR [FundCode]="240" OR [FundCode]="260" OR [FundCode]="310" OR [FundCode]="415" OR [FundCode]="418" OR [FundCode]="428" OR [FundCode]="440" OR [FundCode]="445" OR [FundCode]="448" OR [FundCode]="450" OR [FundCode]="455" AND ([Constituency]="Alumni"),'450070',

IIF([FundCode]="120" OR [FundCode]="130" OR [FundCode]="210" OR [FundCode]="220" OR [FundCode]="230" OR [FundCode]="233" OR [FundCode]="235" OR [FundCode]="240" OR [FundCode]="260" OR [FundCode]="310" OR [FundCode]="415" OR [FundCode]="418" OR [FundCode]="428" OR [FundCode]="440" OR [FundCode]="445" OR [FundCode]="448" OR [FundCode]="450" OR [FundCode]="455" AND ([Constituency]="Parent" OR [Constituency]="Staff" OR [Constituency]="Student" OR [Constituency]="Other Individual"),'450050',3)))))))))))) AS PSAccount, IIf([FundCode]="815" Or [FundCode]="820" Or [FundCode]="870" Or [FundCode]="873" Or [FundCode]="874" Or [FundCode]="875" Or [FundCode]="877" Or [FundCode]="890" And ([Constituency]="Parent" Or [Constituency]="Staff" Or [Constituency]="Student" Or [Constituency]="Other Individual"),'450330',0) AS PSAccount3

FROM (((Gift LEFT JOIN GfFnds_1 ON Gift.GfFnds_1_LINK = GfFnds_1.GfFnds_1_LINK) LEFT JOIN CFSFundType ON GfFnds_1.GfFnds_1Fn_LINK = CFSFundType.GfFnds_1Fn_LINK) LEFT JOIN GfFnds_1FnAtr ON CFSFundType.GfFnds_1FnAtr_LINK = GfFnds_1FnAtr.GfFnds_1FnAtr_LINK) LEFT JOIN CFSFundCode ON GfFnds_1FnAtr.GfFnds_1FnAtrCat_1_LINK = CFSFundCode.GfFnds_1FnAtrCat_1_LINK;