How do I format the output of an expression in a Query to currency

[Guest]

How do I format the output of an expression in a Query to currency?
I’m using the IIF function in a query to get a credit or debit in the
currency format.
I then use another IIF Function to get a total! How do I format the Total to
the currency format. I have tried to do it in the Report and Query and
I cant get it to work..

 

[John Vinson]

How do I format the output of an expression in a Query to currency?
I’m using the IIF function in a query to get a credit or debit in the
currency format.
I then use another IIF Function to get a total! How do I format the Total to
the currency format. I have tried to do it in the Report and Query and
I cant get it to work..

YOu can use the CCur() function to convert a number value (from a
calculation, say) to a Currency datatype; and you can display the
result on a Form or Report textbox with its format property set to
Currency.

John W. Vinson[MVP]