Calculated Query - Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a query using this line*, the problem I am having is my results are not showing up in currency format. When "nz" and ",0" are removed the results show up in currency but for any record left blank nothing is displayed. However, for blank records I want $0.00 to be displayed. Is there a way to accomplish this and stay in currency format? And yes the query is formatted for currency. Any help would be greatly appreciated. Thanks.

*PULSE_COMMITTED: nz([New Table]![SumOfAmount Obligated],0)
 
Try:
PULSE_COMMITTED: format(nz([New Table]![SumOfAmount
Obligated],0),"$0.00")
-----Original Message-----
I am running a query using this line*, the problem I am
Click to expand...
having is my results are not showing up in currency
format. When "nz" and ",0" are removed the results show
up in currency but for any record left blank nothing is
displayed. However, for blank records I want $0.00 to be
displayed. Is there a way to accomplish this and stay in
currency format? And yes the query is formatted for
currency. Any help would be greatly appreciated. Thanks.
*PULSE_COMMITTED: nz([New Table]![SumOfAmount Obligated],0)

.
Click to expand...
 
I am running a query using this line*, the problem I am having is my results are not showing up in currency format. When "nz" and ",0" are removed the results show up in currency but for any record left blank nothing is displayed. However, for blank records I want $0.00 to be displayed. Is there a way to accomplish this and stay in currency format? And yes the query is formatted for currency. Any help would be greatly appreciated. Thanks.

*PULSE_COMMITTED: nz([New Table]![SumOfAmount Obligated],0)
Click to expand...

Try

CCur(Nz(...))

to convert the number result explicitly to Currency.
 
Works!! Thank You!!

John Vinson said:
I am running a query using this line*, the problem I am having is my results are not showing up in currency format. When "nz" and ",0" are removed the results show up in currency but for any record left blank nothing is displayed. However, for blank records I want $0.00 to be displayed. Is there a way to accomplish this and stay in currency format? And yes the query is formatted for currency. Any help would be greatly appreciated. Thanks.

*PULSE_COMMITTED: nz([New Table]![SumOfAmount Obligated],0)
Click to expand...

Try

CCur(Nz(...))

to convert the number result explicitly to Currency.
Click to expand...
 
Back
Top