Hello I am trying to get the following sum. I am very very new at access so if anyone can help me out that would be great.

I need to get the summary of [deptfunded], but only if they are [authtohire] or checkmarked as yes.

I have tried many different solutions but I getting nowhere. Here is an example of one that I have tried.

Ex: =sum(NZ(Iif([authtohire])=true,1,0([deptfunded]))))

Thanks so much to anyone that can help.

Would this work?

Ex:= Sum(IIf(authtohire = True, deptfunded, IIf(checkmarked = True, deptfunded, 0))