m********n
发帖数: 208 | 1 I wanna put "$0.00" on a report, but the default for zero
value is blank space, how can I change the setup in the
query or table? | v**m
发帖数: 242 | 2 try to set the default value is 0. also the type is currency
【在 m********n 的大作中提到】
: I wanna put "$0.00" on a report, but the default for zero
: value is blank space, how can I change the setup in the
: query or table?
| v**m
发帖数: 242 | 3 BTW, you can do so in table design
【在 v**m 的大作中提到】
: try to set the default value is 0. also the type is currency
| m********n
发帖数: 208 | 4 I tired, but it didn't work. Thanks anyway.
~{!>~} ~{TZ~} vbnm (~{P!MC9T9T~}) ~{5D4sWwVPLa5=~}: ~{!?~} | v**m
发帖数: 242 | 5 then try to define the format as
$#,##0.00;($#,##0.00);"$0.00";"$0.00"
Then null or zero value will be replaced by $0.00
the default value should be 0
【在 m********n 的大作中提到】
: I tired, but it didn't work. Thanks anyway.
: ~{!>~} ~{TZ~} vbnm (~{P!MC9T9T~}) ~{5D4sWwVPLa5=~}: ~{!?~}
|
|
