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

M

MAG12

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..
 
J

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..
Click to expand...

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]
 
Top