Unable to set currency format...

T

tvh

I have the following expression in a query:

ExpenseTotal:
nz([tblexpQuantity]*[tblexpCost]*IIf([tblexpPercentage],1.15,1),0)

What do I need to do to set this field to a currency format? The format
drop-down boxes are empty in the query builder and the form's property sheet,
so I'm not able to establish a format that way. Is it because I have the
"nz" in the equation?

Thanks,
T
 
T

tvh

Nevermind: I figured it out.
ExpenseTotal:
Format(nz([tblexpQuantity]*[tblexpCost]*IIf([tblexpPercentage],1.15,1),0),"currency")
 
Top