If in report display amout is "0", how to set into "-" sign ?

[Guest]

I'm having problem about making report in MS-Access that if the amount is "0"
and then I want it to show in "-" sign. I used the command "IFF" but the
result is "#Error". Could you help me please? The command that I used is
=IFF([amount]=0,"-",[amount])

ผมมีปัà¸à¸«à¸²à¸à¸²à¸£à¸­à¸­à¸ report ใน MS Access ว่า ถ้าจำนวนเงินเป็น 0 จะให้พิมพ์เป็น -
à¹à¸—น โดยใช้คำสั่ง IIF ครับ à¹à¸•à¹ˆà¸§à¹ˆà¸²à¸¡à¸±à¸™à¸‚ึ้น #Error ใครทราบช่วยบอà¸à¹ƒà¸«à¹‰à¸«à¸™à¹ˆà¸­à¸¢à¸™à¹ˆà¸°à¸„รับ
สูตรที่ผมทำคือ =IFF([จำนวนเงิน]=0,"-",[จำนวนเงิน])

 

[Duane Hookom]

Use only the Format property. Set it to something like:
0.00;(0.00);"-";Null

 

[John Spencer]

By the way, the "Command" is I I F not I F F . (Spaces added for clarity)
IIF stands for Immediate IF

Use only the Format property. Set it to something like:
0.00;(0.00);"-";Null


--
Duane Hookom
MS Access MVP

I'm having problem about making report in MS-Access that if the amount is
"0"
and then I want it to show in "-" sign. I used the command "IFF" but the
result is "#Error". Could you help me please? The command that I used is
=IFF([amount]=0,"-",[amount])

??????????????? report ?? MS Access ??? ???????????????? 0
?????????????? -
??? ???????????? IIF ???? ????????????? #Error
?????????????????????????????
?????????????? =IFF([?????????]=0,"-",[?????????])