Unable to set currency format...

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I format the output of an expression in a Query to currency 1
Using expression builder to format a report field 4
Query Field Format 2
Loop through a record set to change a currency field based on average difference of two fields 0
Can't set the null or "" text box to be a calculable text box 0
Null value to "0" / Currency format 2
calculated currency field sorts like text instead of numeric 4
Currency Format in a query 1

Top