由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - MC Access expert pls. help
相关主题
Help for VB 6 and MS Access DB怎么准备1Z0-047 Oracle Database SQL Expert考试?
Oracle 有这种 create partially sorted index方法吗?No SQL Expert
~{Gk=L~} CS expert !!!寻找电子书: OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047
Expert,please tell me some "Informix" information.Expert Oracle dba: monthly salary range:$5010 – $6575
Please recommend a good Oracle book for developer求教: 想考ORACLE证书,拿哪个证书合适
申请 database 版版主怎么准备第一份DBA工作
look for a Sql Server 2005 and coldfusion expert31号去考70-452
Experts: Oracle database option price hikes no accident (ZZ)请教,oracle associate 考哪个组合最好?
相关话题的讨论汇总
话题: access话题: mc话题: value话题: expert话题: default
进入Database版参与讨论
1 (共1页)
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=~}: ~{!?~}

1 (共1页)
进入Database版参与讨论
相关主题
请教,oracle associate 考哪个组合最好?Please recommend a good Oracle book for developer
sql要到什么水平才能称得上expert或者advanced呢?申请 database 版版主
hiring experienced sql server developers in 19380 (转载)look for a Sql Server 2005 and coldfusion expert
csv fileExperts: Oracle database option price hikes no accident (ZZ)
Help for VB 6 and MS Access DB怎么准备1Z0-047 Oracle Database SQL Expert考试?
Oracle 有这种 create partially sorted index方法吗?No SQL Expert
~{Gk=L~} CS expert !!!寻找电子书: OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047
Expert,please tell me some "Informix" information.Expert Oracle dba: monthly salary range:$5010 – $6575
相关话题的讨论汇总
话题: access话题: mc话题: value话题: expert话题: default