Setting up Iif statements

[BringTheR41n]

I have set up a query for some tax info, and i want to able to input a number in 1 column and have to query 'grab' information from a currency column. I am able to input the number and have it pull the said currency value but instead of it reading as a currency, it inserts it as a text format, ie: 2 instead of $2.00. Here is the iif statement i have set up for it currentlt...Total 1: IIf([Exemption]="1",[InvoiceTotal],"-"). exemption is the column i want the single number to be and invoice total is the currency column number i want to "Total 1" to show.
Any help is appreciated.

[rpeare]

you can't mix text values and numeric values in the same field your formula should be something like

Total1: iif([Exemption] = "1", [InvoiceTotal], 0)

this assumes exemption is a text field.

[BringTheR41n]

alright. i did that and it worked. for cosmetic purposes would i be able to input it to where the output is a blank instead of zero? i want to make it as easy as possible to quickly read where the numbers are. i have four Total columns to correspond to 4 different exemptions.

[BringTheR41n]

i figured it out. thank you for the help tho. i didnt know that "-" was messing it up.

[rpeare]

yes, you can leave it blank by using NULL instead of 0, just be aware that if you do any other mathematical functions using this value you will have to convert the value to 0 anyway otherwise you may get a 'blank' calculation.