Sum Unbound Textbox with WHERE Clause 1

[RaphDawg]

I have a form with an Unbound text box called NonTaxPrice where I want to SUM records WHERE the Taxable column = -1. Right now I have an Unbound text box named ExtendedPrice that SUMS ALL records to give me a total price. It works as expected but my problem is I need to display a separate amount for taxable and Non-taxable records. I added the Taxable column to identify Non-taxable records, but I can’t figure out how to setup a WHERE clause for another Unbound text box so I can display the Non-taxable amount.
Note I tried the following syntax in the NonTaxPrice Control source but I get a syntax error - You may have entered an operand without an operator:
=Sum (“[ExtendedPrice] ”, “qrySalesDetails”, “[Taxable] = “ & -1)

 

[boblarson]

Actually this should be it:

=Sum(IIf([Taxable]=-1,Nz([ExtendedPrice],0),0)

 

[RaphDawg]

Hey THANKS!!!
Used this syntax:
=Sum(IIf([Taxable]=-1,Nz([ExtendedPrice],0),0)

I now am getting the following error:
The expression you entered is missing a closing parenthesis, bracket (]), or vertical bar (I).
Any thoughts??

 

[RaphDawg]

Thanks I got it!!!
Added parenthesis at the end and it worked!

=Sum(IIf([Taxable]=-1,Nz([ExtendedPrice],0),0))