How to use Queries under the condition

[wdacc]

I have a problem in my query. In my table, I have input A and B. Sometimes B=0. I want A/B in my query. when B=0, A/B => Blank, other have A/B in 2 decimal.

for instance A=1, B=6; or A=0, B=0
I shold have 0.17 (1/6) and [Blank]

 

[PHV]

IIf(B=0, '', Format(A/B,'0.00')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdacc]

PHV,

Thanks for quick answer! But I got message ["The express you entered has an invalid string" -- A string can be up 2048 long, including opening and closing quotation mark].

 

[PHV]

Sorry for the missing closing paren:
IIf(B=0, '', Format(A/B,'0.00'))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdacc]

PHV,

It is not closing paren issue. I tried adding on closing paran. the problem is ",. I can replace " in any number. But if I use ", it alsway says the message above. I wonder how to express "Blank" after IIf=0,

For example if I use IIF=0, 1, Format([a]/,'0.00'), then I get 1 or 0.17. My purpose is get [Blank] and 0.17.

 

[PHV]

And this ?
IIf(=0, ' ', Format([a]/,'0.00'))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdacc]

PHV,

Thanks so much! I got what I want.