And and Or in an IIf Query:

[bali3377]

UnclCrs: Sum(IIf([TaxYrPaid]="2011" And [BankRec]>"0419",[AmountPaidDue],0))

This query field works as it stands however I want to add another element : The BankRec should be 0419 OR Null. I dont know much on the SQL front I use the Access front to build, so any ideas have to be in this format or if in SQL could you write it out exactly as it will look so I can just copy it. Many thanks

 

[thingssocomplex]

Can't you use a nested IIF for both conditions!

 

[Beetle]

UnclCrs: Sum(IIf([TaxYrPaid]="2011" And ([BankRec]>"0419" Or [BankRec] Is Null),[AmountPaidDue],0))