Formatting NZ Function Value

[kermit5]

I have the following code:
.
NZ([Dollar],0,[Dollar])
.
The output is a general number but I need it to be currency. How can I change the output format (in my query and in my report, the format box does not offer currency as a valid format)

 

[David R]

I'm not sure you're using the Nz() function correctly here. If you just use Nz([Dollar]), you should get 0 if [Dollar] is null, simplifying your statement. The exception to this is if you're using Nz() in a query, when you need to use Nz([Dollar],0)

However, back to your statement: Can't you just use Format(Nz([Dollar],0),"Currency")?

HTH,
David R

 

[rohiiit]

Hello guyz,

IIf(IsNull([JCR - Act Lab_Crosstab Hr]![CP]),0,[JCR - Act Lab_Crosstab Hr]![CP])

I am trying to use the following expression. Problem is [CP] exists sometimes, but sometimes not in [JCR - Act Lab_Crosstab Hr]. How can I put an If statement in this expression so that even if cp doesnt exsist, the querry will run?

Please help!!!

Ro

i used this fucntion but access says tht CP doesnt exist

Nz([JCR - Act Lab_Crosstab Hr]![CP],0)