MC Access expert pls. help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MC Access expert pls. help

MC Access expert pls. help# Database - 数据库

m*n2000-08-15 07:08

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*m2000-08-15 07:08

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*m2000-08-15 07:08

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*n2000-08-15 07:08

4 楼

I tired, but it didn't work. Thanks anyway.
~{!>~} ~{TZ~} vbnm (~{P!MC9T9T~}) ~{5D4sWwVPLa5=~}: ~{!?~}

v*m2000-08-15 07:08

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=~}: ~{!?~}

2024-01-28 18:01

2024-01-09 19:01

2024-01-07 18:01

2024-01-06 18:01

2024-01-06 18:01

2023-12-13 17:12

2023-12-02 07:12

2023-11-26 18:11

中美航班重磅消息！每周85班，直飞更方便！

微软、亚马逊、谷歌大裁员！哪些科技和零售公司有缩减规模计划？

中国外长王毅：中美关系已经止跌回稳

脱轨事故造成20多人受伤联邦调查纽约市全部地铁系统

更多 2024-09-29 的新闻